Forum Discussion
formula help
Looking to return a single cell value with multiple criteria.
Sheet1
Column A - List of Customer codes
Column B - List of Product codes
Column C - Prices
Sheet2
Product code in cell A2
Customer code in cell B1
In cell B2 i want to pull in the price from sheet1 where it finds the matching product and customer code.
But 2 factors to consider, in sheet1 there can be multiple customer and product codes that are the same (which do show the same price) so SUMPRODUCT cannot be used as it adds up the prices if it finds the match one than once.
And I cannot use INDEX and MATCH as the formula falls over in the jet report I have written.
Any help appreciated
7 Replies
I didn't catch why you can't use lookup function (INDEX/MATCH, XLOOKUP, etc), what is the jet reports?
- When I ctrl+shift+enter the formula it works in design mode but when I run the jet it loses the ctrl+shift+enter function and throws up an error
But why do you need array formula on on which Excel version/platform you are?
