How to find a currency rate

[Sulirada]

I have two charts: CurrenciesRates and Table1, in Rate Column in the Table1 I need to find a corresponding value from the CurrenciesRates to a proper currency. I'm a beginner and I can't find a solution by my own yet. Thank you in advance.

 

[arnelgp]

use Query to retrieve the value.
See Query1.

 

[Sulirada]

Thank you so much for your help

 

[arnelgp]

you're welcome!