Vlookup in multiple columns

I

Iriemon

I am trying to write a vlookup that looks in more than one column for the
data, is this possible?


Col a Col b Col c col d
1 a 1 a
2 b
3 c
4 d

How do I get a vlookup or other function to find the "2"?

=vlookup(a10,a1:b4;c1:d4,2,false) where a10=2 doesn't work.
 
D

Domenic

Iriemon said:
I am trying to write a vlookup that looks in more than one column for the
data, is this possible?


Col a Col b Col c col d
1 a 1 a
2 b
3 c
4 d

How do I get a vlookup or other function to find the "2"?

=vlookup(a10,a1:b4;c1:d4,2,false) where a10=2 doesn't work.

Is this what you mean?

=VLOOKUP(A10,IF(ISNUMBER(MATCH(A10,A1:A4,0)),A1:B4,C1:D4),2,FALSE)
 

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

Top