Looking a formula to convert local currency to USD by matching com

G

Guest

Amount in Local Currency
Col "Y" Col "AH"
Co # Reserve Convert to USD by matching Co #
001 65000 ?
002 650000 ?
003 450000 ?
004 30000 ?
005 375000 ?
006 42500 ?



Exch Rate Table
LC Co # Rate
AUD 001 1.327
KRW 002 968.75
NZD 003 1.458
SGD 004 1.6205
HKD 005 7.7572
TWD 006 31.9675
 
G

Govind

Hi,

Use

=B2/VLOOKUP(A2,$B$13:$C$18,2,FALSE)

Where B2 has local currency and A2 has company code inthe first table
and B13:C18 is where the Exchange rates in the second table are.

Regards

Govind.
 
Top