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 ...
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?
- I just want a formula that works, if i can get the index/match working then perfect, if not i need another.
Perhaps I misunderstood what is "multiple customers and products codes", which variant here is yours?