Lookup? for more than one criteria
Try this:
=INDEX(Sheet2!H1:Z50,MATCH(B3,Sheet2!B1:B50,0),MAT CH(B2,Sheet2!H1:Z1,0))
I'm assuming that your product list and price actually starts in row 2
not row 1. I'm also assuming that cell B3 on sheet1 contains the
product you want to look up.
|