ExcelBanter - Vlookup in multiple columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup in multiple columns (https://www.excelbanter.com/excel-worksheet-functions/230003-vlookup-multiple-columns.html)

Iriemon

Vlookup in multiple columns

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.

Domenic[_2_]

Vlookup in multiple columns

In article ,
Iriemon wrote:

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)

--
Domenic
http://www.xl-central.com

Iriemon

Vlookup in multiple columns

Works perfectly!

Thanks

Irie !!

"Domenic" wrote:

In article ,
Iriemon wrote:

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)

--
Domenic
http://www.xl-central.com

All times are GMT +1. The time now is 10:57 AM.