ExcelBanter - Have 2 Vlookup

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

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

- - Have 2 Vlookup (https://www.excelbanter.com/excel-worksheet-functions/70440-have-2-vlookup.html)

LÃ©na

Have 2 Vlookup

I would like to have 2 Vlookup functions in the same formula. The first one
look up in a table a number and the 2nd lookup will look up that number in
another table. Is it possible and thank you in advance.

Niek Otten

Have 2 Vlookup

Sure.

=VLOOKUP(VLOOKUP(A1,F1:G5,2,FALSE),I1:J5,2,FALSE)

Just an example

--
Kind regards,

Niek Otten

"Léna" wrote in message
...
I would like to have 2 Vlookup functions in the same formula. The first
one
look up in a table a number and the 2nd lookup will look up that number in
another table. Is it possible and thank you in advance.

All times are GMT +1. The time now is 07:16 PM.