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 ...
The index and match worked fine on initial test, however I have written this within a jet report (which i have just found out does not like arrays)