Index and Match - Problem

[abshmo5]

Hi Everyone

I need help and i think this forum is an answer to my question:

Question:
How can i insert formula on L column that will result the value from column E if the criteria
on column J and I matches on column B and C, and Column K will also match to the Column D
Column D is a range, but column K is fixed.


Please See attached fileSample.xlsx

[benishiryo]

hi abshmo5, welcome to the forum. try this in L3:

Please Login or Register  to view this content.

[abshmo5]

Thank you so much you help a lot benishiryo...wow im amaze

[abshmo5]

hello, whats wrong with my formula,

=SUMPRODUCT((Pricing!A2:A1048576=K2)*(Pricing!B2:B1048576=K3)*(Pricing!C2:C1048576=H13)*(Pricing!D2:D1048576=I13)*(LEFT(Pricing!E2:E1048576,FIND(("-",Pricing!E2:E1048576)-1)+0<=J13)*(MID(Pricing!E2:E1048576,FIND("-",Pricing!E2:E1048576)+1,9)+0>=J13),Pricing!F2:F1048576)

Excel return an error message

Thanks

Ariel

[Teethless mama]

See the attached for your reference to your real workbook. You might to adjust to suit your need.