Index Match on multiply columns

Hello All,

truing to index match on multiply column what i am truing to do is:

=INDEX(Sheet1!C2:C14, MATCH(1, (Sheet1!C2 = Table2[Product]) * (Table2[Posting Date] > Sheet1!A2) * (Sheet1!D2 = Table2[Difference Quantity]), 0))

1) Sheet1[Product] == Sheet2[Product]
2) Date[Sheet2] > Date[Sheet2]
3) Sheet1[Difference Quantity] == Sheet2[Difference Quantity]

Please if you have time check attached file, formula is on Result.

Thanks in advance have a great day!

You showed us a formula that does not work, but did not tell us what teh expected answers are... So a total guess:

=IFERROR(INDEX(Sheet1!$C$3:$C$14, MATCH(1, (Sheet1!C2 = Table2[Product])* (Table2[Posting Date] > Sheet1!A2) *(Sheet1!D2 = Table2[Difference Quantity]), 0)),"")

No, I measnt manually calculated expected answers. I can see that they're meant to come from Sheet1!C2:C14... but I actually think you meant Sheet1!$C$2:$C$14

Is it possible to receive Sheet1[Product] as result, based on those three condition, or its not possible to index and match on same column Sheet1[Product]?

Please, please look at the sheet I posted. Does it give the correct result? If not... type (manually) the correct result in an adjacent column.

Phew. I was 99.999% certain that was all your problem was, but we weren't getting through to each other for a while...

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.