How to create double vlookup in Excel?

DanteAmor

Well-known Member
Not sure what you need.
Better explain what you need result.
Maybe it's another formula I would need it

I put the image so you can explain it.

 

adan96

New Member
Not sure what you need.
Better explain what you need result.
Maybe it's another formula I would need it

I put the image so you can explain it.

I should use double vlookup to find Country Code based on CCA and Customer in columns F&G.
 

Mentor82

Board Regular
Hi,
Type in the following formula in cell H2 and then autofill in down the range in column H. It's an array formula so once you type it in in H2 confirm it by clicking CTRL+SHIFT+Enter
Place the following formula in only cell H2
=index($C$2:$C$19,match(F2&G2,$A$2:$A$19&$B$2:$B$19,0))
...and hit ctrl+shift+enter. This will acrivate this as array formula so it gets {}at the beginning and end of the areay formula and it will look like this

{=index($C$2:$C$19,match(F2&G2,$A$2:$A$19&$B$2:$B$19,0))}

Then, autofill in this formula from range H2 down the cells in column H
 

Some videos you may like

This Week's Hot Topics

Top