Have 2 Vlookup

[Léna]

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]

Sure.

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

Just an example