I found a index + match Google sheet formula to find a cell based on row AND column. But I was wondering if it's possible to do it with 2 conditions from the header.
I have 2 scenario represented in sheet 1 and sheet 2:
FIRST: find the cost share of a certain product for a specific market
SECOND: find the cost share of a certain product from a specific range and for a specific market
I would appreciate any help you could provide, please
find a cell from multiple values.xlsx