multiple nest vert

[theramyrez]

Hi

How i can do that with multiple find vert ?

data num A B
01-lug 1 xxxxxx eeeeww
01-lug 2 xxxxxx eeee
01-lug 3 xxxx eee
02-lug 1 xxxxx yyy
02-lug 2 xxxx erer
02-lug 3 xxxx erer

I would like that the find.vert, my insert is the data of today and the shift and this tell me the colon B like
Insert 01-luglio 2 => it give me eeee

i can use a pivot table but i need a lot of coloun like that
thanks

Carlos

 

[Claus Busch]

Hi Carlos,

Am Thu, 4 Jul 2013 00:13:24 -0700 (PDT) schrieb (e-mail address removed):

data num A B
01-lug 1 xxxxxx eeeeww
01-lug 2 xxxxxx eeee
01-lug 3 xxxx eee
02-lug 1 xxxxx yyy
02-lug 2 xxxx erer
02-lug 3 xxxx erer

I would like that the find.vert, my insert is the data of today and the shift and this tell me the colon B like
Insert 01-luglio 2 => it give me eeee

01-lug in F1 and 2 in G1 then try:
=INDEX(D1100,MATCH(F1&"*"&G1,A1:A100&"*"&B1:B100,0))
and enter the array formula with CTRL+Shift+Enter


Regards
Claus B.