How to get currency rate in table with PQ?

[greg_em]

I have workbook with power query queries. I'm trying to get currency rates into yellow column, based on parameters specified in green column (currency symbol) and blue column (date).

Query refer to internet csv, updated every workday, so I would prefer to not downloading full data table into workbook, but only looked rates for specified days.

Any idea how to do it with M?

Link to workbook:
Dropbox

 

[alansidman]

It would make more sense if you identified the common columns that you wish to join by identifying the column as you have several blue columns. A mocked up solution would certainly help as we are not mind readers.