Multiple criteria lookup

[kahnailee]

See attached. I need a way to do a lookup based on the product, date, and company in order to fill the lower tables.

Book2.xlsx

[JohnTopley]

Try ..

in B11


=INDEX($B$3:$G$7,MATCH($A$10,$A$3:$A$6,0),MATCH(1,($B$2:$G$2=B$10)*($B$1:$G$1=$A11),0))

Enter with Ctrl+Shift+Enter

Copy across and down

Change A10 to A15 for product B and similar changes for other products.

[AlKey]

Please see attached file.

[kahnailee]

Please see attached file.

Excellent, thanks!