Spreadsheet: 777774d1650612839-match-if-vlookup-to-populate-a-list-of-data-and-corresponding-values-based-on-a-data-soa-sample
Sheet: Sample Database

Invoice No | PO NUMBER | Department | Client Name | Invoice Date | Amount in Euros | Amount in Aed | Due Date
FZE 4527-TI | 3052100373 | Service | Customer D | 2021-02-21 00:00:00 |  | 2625 | 2021-03-25 00:00:00
FZE 4728 | 3012101382 | Spares | Customer D | 2021-05-27 00:00:00 |  | 28 | 2021-06-27 00:00:00
FZE 5164-TI | 111/P124/SPO/20-21/09429 | Service | Customer R | 2021-08-31 00:00:00 |  | 20160 | 9/31/2021
FZE 5180 | 3012103060 | Spares | Customer D | 2021-09-29 00:00:00 |  | 13835 | 2021-10-30 00:00:00
FZE 5232 | 91/2021/A99 | African-Sales | Customer A | 2021-10-11 00:00:00 | 14265.39 |  | 2022-01-11 00:00:00
FZE 5241 | 94/2021/A82 | Freight Charges | Customer A | 2021-10-16 00:00:00 | 480 |  | 2022-02-16 00:00:00
FZE 5247-TI | 111/P119/SPO/21-22/04822- | Service | Customer R | 2021-10-10 00:00:00 | 997.5 |  | 2021-11-10 00:00:00
FZE 5251 | 102/2021/ A100 | African-Sales | Customer A | 2021-10-11 00:00:00 | 2736 |  | 2022-02-11 00:00:00
FZE 5253 | 116/2021/A108 | African-Sales | Customer A | 2021-10-11 00:00:00 | 656.64 |  | 2022-02-11 00:00:00
FZE 5258 | 100/2021/ A101 | African-Sales | Customer A | 2021-10-11 00:00:00 | 1545.84 |  | 2022-02-11 00:00:00
FZE 5264 | 94/2021/A82 | African-Sales | Customer A | 2021-10-16 00:00:00 | 9508.97 |  | 2022-02-16 00:00:00
FZE 5265 | 93/2021/A98 | African-Sales | Customer A | 2021-10-16 00:00:00 | 4084.62 |  | 2022-02-16 00:00:00
FZE 5266 | 124/2021/ A111 | African-Sales | Customer A | 2021-10-16 00:00:00 | 2975.4 |  | 2022-02-16 00:00:00
FZE 5267 | 84/2021/A124 | African-Sales | Customer A | 2021-10-16 00:00:00 | 595.08 |  | 2022-02-16 00:00:00
FZE 5302 | 3412100106 | Spares | Customer D | 2021-11-28 00:00:00 |  | 865458 | 2021-12-28 00:00:00
FZE 5307 | 114/2021/A117 | African-Sales | Customer A | 2021-10-27 00:00:00 | 34035.27 |  | 2022-02-27 00:00:00
FZE 5308 | 121/2021/A119 rev. | African-Sales | Customer A | 2021-10-27 00:00:00 | 5897.22 |  | 2022-02-27 00:00:00
FZE 5310-TI | 111/P124/SPO/21-22/05329 | Service | Customer R | 2021-10-28 00:00:00 |  | 7350 | 2021-11-28 00:00:00
FZE 5311 | 4500014735 | Service | Customer M | 2021-10-28 00:00:00 | 400 |  | 2021-11-28 00:00:00
FZE 5317 | 4500014732 | Service | Customer M | 2021-10-28 00:00:00 | 650 |  | 2021-11-28 00:00:00
FZE 5321 | 126/2021/P115 | African -Spares | Customer A | 2021-10-30 00:00:00 | 374.49 |  | 30/02/2022
FZE 5322 | 112/ 2021/134rev | African -Spares | Customer A | 2021-10-30 00:00:00 | 1688.75 |  | 30/02/2022
FZE 5329 | 118/2021/ A110 | African-Sales | Customer A | 2021-10-30 00:00:00 | 3692.46 |  | 30/02/2022
FZE 5330 | 126/2021/A116 | African-Sales | Customer A | 2021-10-30 00:00:00 | 2768.49 |  | 30/02/2022
FZE 5331 | 119/2021/A118 rev. | African-Sales | Customer A | 2021-10-30 00:00:00 | 1597.14 |  | 30/02/2022
FZE 5332 | 139/2021/A126 | African-Sales | Customer A | 2021-10-30 00:00:00 | 1134.87 |  | 30/02/2022
FZE 5361 | 4500015004 | Service | Customer M | 2021-11-15 00:00:00 | 1853.42 |  | 2021-12-15 00:00:00
FZE 5362 | 4500013824 | Spares | Customer M | 2021-11-15 00:00:00 | 421 |  | 2021-12-15 00:00:00
FZE 5368 | 4500014764 | Spares | Customer M | 2021-11-19 00:00:00 | 870.99 |  | 2021-12-19 00:00:00
FZE 5369 | 3412100150 | S+Spare | Customer D | 2021-12-14 00:00:00 |  | 1489991 | 2022-01-14 00:00:00