How to create double vlookup in Excel?

adan96

New Member
Joined
Jul 30, 2018
Messages
7
2f9592ebe0b99.jpg.html

I'm gonna search for Country Code for the criteria below:
2f9592ebe0b99.jpg.html
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. ;)
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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.

f2d7aea8b7a82fe9f7eaba4c7b0fb2f8.jpg
 
Upvote 0
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.

f2d7aea8b7a82fe9f7eaba4c7b0fb2f8.jpg

I should use double vlookup to find Country Code based on CCA and Customer in columns F&G.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,938
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top