Have you tried to use the formula I proposed in post #2 to your data. Namely E6:
Formula:
=IFERROR(VLOOKUP(E6,Data!$H$2:$J$97,3,FALSE),INDEX(Data!$H$2:$H$97,MATCH(E6,Data!$J$2:$J$97,0)))
(it's the simplified version, as used in the attachment - without outmost Iferror
of course it can be added:
Formula:
=IFERROR(VLOOKUP(E6,Data!$H$2:$J$97,3,FALSE),IFERROR(INDEX(Data!$H$2:$H$97,MATCH(E6,Data!$J$2:$J$97,0)),"not found"))
May be (I've not analyzed the data) all ranges shall be shortened to ...$81 , to cover only Oct 14th results and similar formula shall be written for Oct 15th (so ranges starting not from ...$2:... but with ...$82:....
Bookmarks