INDEX & MATCH w multiple criterias?

[Eemmai]

Hi,

Again.

I thought I had this down. But now I have a new problem. I recently tried moving numbers w the SUMIFS function but I need to move letters, words, and then that function does not seem to work as I just get 0, correct? So I've created this example of what I'm trying to do; I want to get the correct "Deliver to" country name from the right chart into the left one. The combos are unique which is why I need something testing multiple criterias.

Thank you,
Emma

[benishiryo]

hi Emma, not sure if i got you right. try copying this formula & paste into the formula bar of D5:
=INDEX($N$5:$N$14,MATCH(A5&B5&C5,$K$5:$K$14&$M$5:$M$14&$L$5:$L$14,0))

then press CTRL + SHIFT + ENTER. D6 will have an error because it Product needs to be standardised. is it "Yellow" or "Yellow Shoe"? if you need to hide errors, try:

Please Login or Register  to view this content.

[Eemmai]

Sorry, yes Yellow should be Yellow Shoe.

[Eemmai]

Thank you so much! It worked! I really don't get it sometimes.. in some formula i use multiple criterias seperated by * and then now the &. Lost lost lost! But hey, the formula works! Big thanks!