fomula which returns the amount depending on the currency code

N

Narnimar

I have a list of Currency codes (like USD, EUR. GBP etc.) in h1:h10 and my
local exchange rate in i1:i10. In the cell a1 I have the Currency code in
text and my Purchase Price in b1. I want a fomula which returns the amount
in local currency in e1 depending on the currency code in the cell a1.
 
B

Bernard Liengme

=VLOOKUP(A1,H1:H10,2,0)*B1
If you plan to copy this down the column, make H1:H10 absolute
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement for equivalent value of a range 4
if condition on currency formated cells 4
Converting amount($) of my expenditure into the base currency i wa 1
Median continued 12
Currency automation 3
Match a currency with its corresponding value 4
foreign currency querry and design question 2
Currency format 8

Top