Multiple Criteria Look up Text result

[skjolsc]

So basically I am looking to build a formula that would take this information and return a text value.

if it could work anything like this sumproduct formula to bring back text that would be awesome:
<CODE>=SUMPRODUCT(--(A1:A10="7654321"),--(B1:B10="ABCDE"),--(C1:C10="3"),D1:D10)

But instead of a formula that returns a sum of values, the return is a single value. The three criteria will always be unique. There will never be a case where there is a duplicate of all three.

Thanks to any and all for the help!</CODE>

 

[Andrew Poulsom]

Try:

=INDEX(D1:D10,MATCH(1,INDEX((A1:A10="7654321")*(B1:B10="ABCDE")*(C1:C10=3),),0))

 

[skjolsc]

This is amazing. Thank you very much!