Vlookup two values to give a third

Tucker92

Board Regular
Joined
Jun 7, 2018
Messages
53
I have a database and i am am trying to use vlookup or index and match to find the quantity of my parts

I have to look for two different numbers and then when it finds a row with both of them it will return a third number from that row

I have been trying to use this but it doesnt seem to be working
=INDEX(Table2[EXTENDED_USEAGE],MATCH(D2,Table2[TOP_LEVEL],0),MATCH(A2,Table2[CSS_ITEM],0))

Can anyone help me and tell me why

Thank you
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
colorsizenumberhelper
reds41
bluem5challenge
greenm6identify every row with red and s
pinkl7
redl8
bluel9I used row number to mark them
greensize4
pinkm5easy now to add the 4 and 7
redm6or to list them separately
bluel7
greenl8
pinkl9
reds713
bluem5
greenm6
pinkl7

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
 
Upvote 0
217207ettjtrtgj1325645ryghjrtjrtjrfthjj
217207erh6ujtd1458963rtyjdfhdewyjyhgjt

<tbody>
</tbody>

I need to use the 2 red numbers to search the other sheet to get the green number but as you can see there are many of the second number to go with a recurring 1st number.

Then the first number will change and there are another set of second numbers to go with it
 
Upvote 0
I have a database and i am am trying to use vlookup or index and match to find the quantity of my parts

I have to look for two different numbers and then when it finds a row with both of them it will return a third number from that row

I have been trying to use this but it doesnt seem to be working
=INDEX(Table2[EXTENDED_USEAGE],MATCH(D2,Table2[TOP_LEVEL],0),MATCH(A2,Table2[CSS_ITEM],0))

Can anyone help me and tell me why

Thank you

Try this array formula
=INDEX(Table2[EXTENDED_USEAGE],MATCH(1,(Table2[TOP_LEVEL]=A2)*(Table2[CSS_ITEM]=D2),0))
confirmed with Ctrl+Shift+Enter, not just Enter

M.
 
Upvote 0
oops...
New version
=INDEX(Table2[EXTENDED_USEAGE],MATCH(1,(Table2[TOP_LEVEL]=D2)*(Table2[CSS_ITEM]=A2),0))
Ctrl+Shift+Enter

M.
 
Upvote 0
Sorry should have said that the green number in my example isnt always a 1

I know the number isn't always a 1.
Try the array formula in post 7 - the formula should be confirmed with Ctrl+Shift+Enter simultaneously.

M.
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,297
Members
448,564
Latest member
ED38

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