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('Sheet 1'!$J$6:$J$20, MATCH(1, ('Sheet 1'!$H$6:$H$20=F7)*('Sheet 1'!$I$6:$I$20=Z4), 0))
Replace Sheet 1 with the actual name of that sheet.
If you don't have Microsoft 365 or Office 2021, you should confirm the formula with Ctrl+Shift+Enter.