How to use lookup to find value at the intersection of a date and name

Hi,
I use the simple lookup function often to find a value on a specific row for the date chosen. However, in the attached sheet i want to find the date/description i have on Row 1 of the lookup tab and then do a vlookup on the data sheet for the name listed in the A column.

For example, I want to find "4/19/2022 (U3 offline 37 days)" on the data tab and then have it find "[ABS1][Aluminum Total as Al - Scrubber Unfiltered]" and return that value.....12.4 in this case. I currently have it set up to pull in the value by row number but the position of these names will change going forward and so it won't be effective to do it this way.

thanks so much!
mufan

worksheet or Tab name : Lookup

Cell C3 formula , Drag down

Formula:

Please Login or Register  to view this content.

both of these work great. thanks!