I have a database of temperatures sorted chronologically on sheet 2 column A = dates, column B = temperature. I have certain dates on sheet 1 that correspond to dates of events. How can I insert the temperature based on sheet 2 (temperature database) that correspond to the date of the event.
SHEET 1
A B
DATE TEMP
Jan 1 ?
Feb 5 ?
Mar 6 ?
SHEET 2
A B
DATE TEMP
Jan 1 10
Jan 2 12
Jan 3 15
... ... etc.
Bookmarks