Forum Discussion
Multiple match and lookup
Sheet 1 Column h6:h20 (list of product numbers) Column i6:i20 (list of customer numbers) Column j6:j20 (list of prices) Sheet 2 Cell f7 (a product number, that can be matched in Sheet1 ...
=INDEX(Tabelle1!J6:J20,MATCH(1,(Tabelle1!H6:H20=Tabelle2!F7)*(Tabelle1!I6:I20=Tabelle2!Z4),0))Maybe with this formula like in the attached file. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.