fomula which returns the amount depending on the currency code
 

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.

fomula which returns the amount depending on the currency code
 

In E1: =B1*VLOOKUP(A1,H1:I3,2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Narnimar" wrote:
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.

fomula which returns the amount depending on the currency code
 

=VLOOKUP(A1,H1:H10,2,0)*B1
If you plan to copy this down the column, make H1:H10 absolute
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Narnimar" wrote in message
...
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.

fomula which returns the amount depending on the currency code
 

That should be H1:I10, sorry !!!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
=VLOOKUP(A1,H1:H10,2,0)*B1
If you plan to copy this down the column, make H1:H10 absolute
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Narnimar" wrote in message
...
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.