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
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