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.

Formula in cell C4: =A4*VLOOKUP(B4,E$4:F$7,2,FALSE)

Copy formula down

You are right Debraj!

=A4/VLOOKUP(B4,E$4:F$7,2,0)

Thanks for the above replies and help. Yes, the last formula is what I needed; it works now.

Additional to this (so as to have just a blank cell output in C4, if no entry is made in B4), how could I incorporate a "IF,A4>0" type argument into the formula?

I just solved my extra query above, so nothing outstanding.
Thanks again for the quick replies and assistance.