VLOOKUP and IF

[EMY245]

Hello,

I am trying to use the VLOOKUP function whereby it will firstly lookup the value in cell A1 in 'sheet2' and display a column, but if it cannot find a match, i then want it lookup the same value in 'sheet3'.

I am struggling with the formula for this - whether to use =IF(ISERROR(VLOOKUP.... and in which order it needs to be displayed.

Appreciate any help!

 

[jmacleary]

This is the formula needed - replace the ranges A1:B11 with your desired ones as necessary.

=IF(ISNA(VLOOKUP(A1,Sheet2!A1:B11,2,FALSE)),VLOOKUP(A1,Sheet3!A1:B11,2,FALSE),VLOOKUP(A1,Sheet2!A1:B11,2,FALSE))

 

[EMY245]

Perfect.

Thanks so much.

 

[jmacleary]

You are very welcome, glad to have been of help.

For completeness, I should also have said to replace the column number (2 in my example) with the column number you are trying to retrieve, but it looks like you worked that out anyway.