Calculating amounts in a single currency from a list of multiple currency amounts

I thought this would have been covered prior, but unable to find an answer via searching the site.

In the attached file, I seek to have a formula that will upon checking which currency will reference a given cell to use that number to calculate the British Pound (GBP) equivalent.

The rates would all be divided into the “Amount” cells to yield the GBP equivalents.


Thanks in advance for any assistance.