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 ...
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?
- the last one, i tried a sumproduct formula but based on the last variant it finds the match for customer A and Product 123 but returns 30 (as it would with a sum) and not 10
For the last one INDEX/MATCH without CSE shall work. You find the price for the first matched record, doesn't matter how many the same do you have.