Looking for a formula to match data in both A1 & B1 (blue cells) in trim sheet to:
• Display min price (see orange cells and pricing tab)
• Display engine name matched (see yellow cells and engine tab)
Any help is appreciated. Sample workbook attached VLOOKUP_Multivalue.xlsxVLOOKUP_Multivalue.xlsx
Bookmarks