Hello all - excel novice here been handed a rather tricky puzzle to solve so I'd be extremely grateful for any help.
On Sheet1 I have 5 data validation menus from which you can select a number of options for a product. (Option1,Option2,Option3,Option4,Option5)
Based on these selections, I need to search their corresponding columns on sheet 2. (ColumnA,ColumnB,ColumnC,ColumnD,ColumnE)
I need excel to find the row in sheet 2 where all options criteria are satisfied, then offset to columnF and extract its price.
So, if Sheet1, A1 = Sheet2, A:A and
Sheet1, A2 = Sheet2, B:B and
Sheet1, A3 = Sheet2, C:C and
Sheet1, A4 = Sheet2, D:D and
Sheet1, A5 = Sheet2, E:E
Then match corresponding columnF value. Any suggestions?
Thanks in advance for your help!
P
Bookmarks