Hello.

I have a production sheet where I controll the production of our 3 products
by date like:

a1, b1 and c1 are merged as date
a2 prod1  b2 prod2  c2 prod3
a3 quant1 c3 quant3 c3 quant3

I need to get tthe quantity of a specific product at a specific date.
HLOOKUP doesn´t work because of the merged cells at the top. (Always will
get the info of the first column)

Trying to do it using INDEX and MATCH but I´m loosing it at the poitn that I
have to give 2 different criteria to search for. (date and product)

Thanks for the help.

Markus