Lookup value with multiple conditions

[parveenpry]

Lookup value with multiple conditions as per sheet

[acroley1]

Code looks unique...Is there a need to look up Channel and Prd if Code is a unique value?

If you can just look by Code and Weight, here's a possibility:
=INDEX($A$1:$FV$9,MATCH($F17,$D$1:$D$9,0),MATCH($G17,$A$2:$FV$2,0))

---

If you found this post to be helpful, or if it at least brought a smile to your face, please say "Thank You" by clicking Add Reputation. Thank you!

[parveenpry]

channel and prd are different different , in index and match picking only two time conditions ,if conditions more then 2 time , lick in the sheet 1 channel, 2 prd, 3 code, 4 weight...

[acroley1]

Will there ever be repeats in the Code column?

[parveenpry]

code column not repeats, i just want to know any look formula that can help in this sheet with 4 conditions