Suppose you have the rates in Sheet2 A1:B4

With EUR in A1
=B1*VLOOKUP(A1,Sheet2!$A$1:$B$4,2,0)

If this post helps click Yes
---------------
Jacob Skaria


"Rechie" wrote:

Hi Specialist,

How can I get the Currency value of a range for below table:
Col A (Currency) Column B (Price)
EUR 100
GBP 150
SEK 125
USD 170

Results in In Column C should be: (Currency convertion to SAR)
If A1=EUR, then B1*5.30
If A1=GBP, then B1*6.07
If A1=SEK, then B1*0.51
If A1=USD, then B1*3.75

Thanks for your assistance.
Rechie