|I think this is what your looking for, try this:|
On Sheet 2, in cell J2 enter the formula:
Drag down to J117
This will check to see if there is a Match between cell H2
and any cell in the range D2 thru D76 on sheet 3.
On Sheet 2, in cell K2 enter the formula:
Drag down to K117
First we check cell J2 and see if there is a Match,
if TRUE we then do a VLOOKUP to get the temperature reading.
See how that works.
message edited by mmcconaghy