Match 2 columns and return value from a third

Hello,

Please see the attached spreadsheet. I am trying to find a way to search Column F for a value that corresponds with a date in column E and then enter that value in column A as it matches with the date, and then bring it down to the entire column.

Much appreciated.

Try this in A3 and copy down;

Formula:

Please Login or Register  to view this content.

That worked - You're a life-saver!