Using VLOOKUP

[lukela85]

Hi all,

I have a VLOOKUP function which currently searches the first column of a range of cells as per normal. However in my spreadsheet the result I am looking up is sometimes stored in column 2. Is there a way I can get a VLOOKUP to search the first 2 columns of data and return a value.

Thanks,

Luke

[sunflowers]

Plz, post a sample file.

[martindwilson]

you could do it like this
=IF(ISNA(VLOOKUP(E1,A1:D20,4,FALSE)),VLOOKUP(E1,B1:D20,3,FALSE),VLOOKUP(E1,A1:D20,4,FALSE))
or
=INDEX(D1:D20,IF(ISNUMBER(MATCH(E1,A1:A20,0)),MATCH(E1,A1:A20,0),MATCH(E1,B1:B20,0)))

[lukela85]

Thanks.

As always it works perfectly for what I need