multiple nest vert
 

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

multiple nest vert
 

Hi Carlos,

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

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(D1:D100,MATCH(F1&"*"&G1,A1:A100&"*"&B1:B100 ,0))
and enter the array formula with CTRL+Shift+Enter


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2