zarealshook
New Member
- Joined
- May 26, 2014
- Messages
- 16
- Office Version
- 2016
- Platform
- Windows
Hi everyone,
First of all, I have installed the Add-In XL2BB but when I click on the MiniSheet, the Excel file gets hanging and then I need to close it and reopen again. This has happened for 4 times.
I have the following issue:
If the "Currency" is "USD", keep the "PO Amount" as it is. If the "Currency" is anything else, then refer to the other sheet "Forex" and pull the corresponding exchange rate for the "Currency" to fill the column "PO Amount USD". The important thing is that it has to read the correct corresponding Month-Year exchange (January-2023) rate accordingly.
PO Data Sheet:
FOREXT SHEET:
I tried it with IF & VLOOKUP functions but I couldn't complete it properly.
Any early help will be appreciated,
Zare
First of all, I have installed the Add-In XL2BB but when I click on the MiniSheet, the Excel file gets hanging and then I need to close it and reopen again. This has happened for 4 times.
I have the following issue:
If the "Currency" is "USD", keep the "PO Amount" as it is. If the "Currency" is anything else, then refer to the other sheet "Forex" and pull the corresponding exchange rate for the "Currency" to fill the column "PO Amount USD". The important thing is that it has to read the correct corresponding Month-Year exchange (January-2023) rate accordingly.
PO Data Sheet:
PO DATE | CURRENCY | PO AMOUNT | PO AMOUNT USD | |
15/01/2022 | SDG | 5,250,000.00 | =IF("CURRENCY"="USD",PO Amount,
| |
22/07/2022 | SDG | 155,700.00 | ||
26/04/2022 | SAR | 98,625.00 | ||
31/10/2022 | EGY | 140,000.00 | ||
31/07/2022 | AED | 40,120.00 | ||
01/05/2022 | USD | 28,000.00 | ||
17/09/2022 | EUR | 36,000.00 | ||
06/01/2023 | SDG | 1,853,000.00 | ||
18/05/2022 | GBP | 28,400.00 | ||
08/01/2023 | AED | 163,000.00 |
FOREXT SHEET:
Date | USD | SDG | EUR | GBP | AED | SAR | EGY |
January-2022 | 1.00 | 583.00 | 0.93792 | 0.82090 | 3.6725 | 3.7585 | 27.18199 |
February-2022 | 1.00 | 582.80 | 0.93612 | 0.82880 | 3.6725 | 3.7585 | 27.18187 |
March-2022 | 1.00 | 581.00 | 0.93432 | 0.83070 | 3.6725 | 3.7585 | 27.18175 |
April-2022 | 1.00 | 580.90 | 0.93253 | 0.83261 | 3.6725 | 3.7585 | 27.18162 |
May-2022 | 1.00 | 588.89 | 0.93073 | 0.83451 | 3.6725 | 3.7585 | 27.18150 |
June-2022 | 1.00 | 583.50 | 0.92893 | 0.83641 | 3.6725 | 3.7585 | 27.18138 |
July-2022 | 1.00 | 581.25 | 0.92714 | 0.83832 | 3.6725 | 3.7585 | 27.18126 |
August-2022 | 1.00 | 587.63 | 0.92534 | 0.84022 | 3.6725 | 3.7585 | 27.18113 |
September-2022 | 1.00 | 584.12 | 0.92355 | 0.84212 | 3.6725 | 3.7585 | 27.18101 |
October-2022 | 1.00 | 586.87 | 0.92175 | 0.84402 | 3.6725 | 3.7585 | 27.18089 |
November-2022 | 1.00 | 584.66 | 0.91995 | 0.84593 | 3.6725 | 3.7585 | 27.18076 |
December-2022 | 1.00 | 585.76 | 0.91816 | 0.84783 | 3.6725 | 3.7585 | 27.18064 |
January-2023 | 1.00 | 586.03 | 0.91636 | 0.84973 | 3.6725 | 3.7585 | 27.18052 |
February-2023 | 1.00 | ||||||
March-2023 | 1.00 |
I tried it with IF & VLOOKUP functions but I couldn't complete it properly.
Any early help will be appreciated,
Zare