How to create double vlookup in Excel?

[adan96]

I'm gonna search for Country Code for the criteria below:

https://zapodaj.net/2f9592ebe0b99.jpg.html

I do not know how to use neither double vlookup nor index-match.
Can You please create both formulas and explain shortly how it works? Thx in advance.

 

[sandy666]

use PowerQuery (Get&Transform) with Merge feature

 

[DanteAmor]

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]

Sorry, but it should have been a formula

 

[adan96]

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.

 

[sandy666]

If you say so...

Have a nice day

 

[DanteAmor]

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

I do not understand.
Have you found the solution yet?

 

[adan96]

I do not understand.
Have you found the solution yet?

No, can You please provide the correct formula to find Country Codes? ...

 

[adan96]

No, can You please provide the correct formula to find Country Codes? ...

I tried this one: =VLOOKUP($F2&"|"&$G2;A$2:C$501;3;FALSE). Does not work

 

[Mentor82]

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