I need an Excel formula to return a lookup value based on date. The lookup dates and values (exchange rates for each date) are arranged in two columns per year.

More detail in this sample spreadsheet. 

Can anyone help? 

Thank you in advance!

​I need an Excel formula to return a lookup value based on date. The lookup dates and values (exchange rates for each date) are arranged in two columns per year.More detail in this sample spreadsheet. Can anyone help?  Thank you in advance!  Read More

​