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.
Click to expand...

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

Similar Threads

Sum Products with VLOOKUP 3
Using VLOOKUP inside SUMPRODUCT => complex problem 3
Increment a number based on four adjoing cells 2
validation drop down list question 1
Need formula help! 1
Errors encountered when using If & Vlookup formulas 2
If( AND( with VLOOKUP.... 4
data in single column split to multiple col's based on header 2

Top