| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking a formula to convert local currency to USD by matching com
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking a formula to convert local currency to USD by matchingcom
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. Dinesh wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking a formula to convert local currency to USD by matching com
Thanks, Govind
dinesh "Dinesh" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert currency of the whole worksheet | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| How do I convert a cell(s) from the formula to it's contents? | Excel Worksheet Functions | |||
| Convert text to formula - Help pleaaase | Excel Discussion (Misc queries) | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
Hybrid Mode
