We value your feedback.

Take our survey and automatically be enter to win anyone of the following:

Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

If they are in B1:E1 and the Material codes are in A2:A10 then try this formula

=INDEX(B2:E10,MATCH(A12,A2

where A12 = 32 and B12 = 1500

see this article for a better description

regards, barry