multiple nest vert

T

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
 
C

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


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top