In Google Sheets, how to change the data in a cell depending on another one?

Question

Google Sheets

Hello! Help solve the problem.
In Google Docs Sheets: there is a cell in which you can select the type of currency RUR, USD, EUR, ILS
In others, a numerical value is entered, mostly in rubles.
How to make it so that when choosing a particular currency, certain cells are automatically translated at the rate.
The table looks like this:
RUR <1 <3 <5 <10 <15 <20 <25
1 350 350 350 350 500 600 700
2 210 240 250 300 400 450 530
In cell A1, you can choose the currency RUR or USD and so on.
With what script can the data in cells B2:H3 be automatically converted into the selected currency?
In advance, thanks a lot for your help!

Answer 1

https://docs.google.com/spreadsheets/d/1Y-XWI4kgxn...
You can do this

Answer 2

through=A1*GOOGLEFINANCE("CURRENCY:USDGBP")