Thread: Have 2 Vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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.