close
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.
Sure.
=VLOOKUP(VLOOKUP(A1,F1:G5,2,FALSE),I1:J5,2,FALSE)
Just an example
--
Kind regards,
Niek Otten
quot;Lénaquot; gt; wrote in message
...
gt;I would like to have 2 Vlookup functions in the same formula. The first
gt;one
gt; look up in a table a number and the 2nd lookup will look up that number in
gt; another table. Is it possible and thank you in advance.
gt;
gt;
全站熱搜
留言列表
