Spreadsheet: 491757d1480618343-lookup-multiple-values-from-2-different-sheets-stephen_c_example
Sheet: Invoice Lines

PO Number | PO Number and Line | PO Order Date | Supplier | PO Status | GPO Processing Fee | Billing | Line # | Description | Total | Currency | Reporting Total | Created By | Requested By | Invoice # | Invoice Date | GL Date
GPO-029580 |  | 10/10/16 | [NAME] (WVI_GUITY [NAME]) | issued | No | 3100-2630-LCRO-50030-000000-00000 | 1 | Consultancy - LACRO Finance Specialist | 2854.5 | USD | 2854.5 | [NAME] | Nino Gonjilashvili | 11201601 | 11/22/16 | 11/23/16
 |  |  | INTEGRA LEGAL (WVI_INTEGRA LEGAL_28387) |  |  | 3100-2620-LEXO-57525-000000-00000 | 1 | Advice and assistance from [NAME] | 500 | GBP | 716.54 | [NAME] |  | 5968 | 11/11/16 | 11/22/16
 |  |  | INTEGRA LEGAL (WVI_INTEGRA LEGAL_28387) |  |  | 3100-2620-LEXO-57525-000000-00000 | 2 | VAT | 100 | GBP | 143.31 | [NAME] |  | 5968 | 11/11/16 | 11/22/16
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-57520-000000-00000 | 1 | Consultancy - Donor landscaping assessment FY17 | 16500 | USD | 16500 | [NAME] | [NAME] | 3A | 11/17/16
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-52040-000000-00000 | 2 | Reimbursable Travel - FY16 | 262.07 | USD | 262.07 | [NAME] | [NAME] | 3A | 11/17/16
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-52040-000000-00000 | 3 | Reimbursable Travel - FY17 | 1500 | USD | 1500 | [NAME] | [NAME] | 3A | 11/17/16
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-57520-000000-00000 | 1 | Consultancy - Donor landscaping assessment FY17 | 16500 | USD | 16500 | [NAME] | [NAME] | 31 | 11/17/16 | 11/22/16
GPO-031840 |  | 11/17/16 | MCKEON KIMBERLEY ([NAME]) | issued | No | 3100-2620-INLO-57520-000000-00000 | 1 | Consultancy - [NAME] Tanzania technical agriculture advisory services | 29042.5 | USD | 29042.5 | [NAME] | [NAME] | 111316 | 11/13/16 | 11/21/16
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-52040-000000-00000 | 1 | Reimbursable Travel - FY17 | 978.07 | USD | 978.07 | [NAME] | [NAME] | 2 | 11/03/16 | 11/22/16
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-57520-000000-00000 | 1 | Consultancy - Donor landscaping assessment FY17 | 16500 | USD | 16500 | [NAME] | [NAME] | 3 | 11/17/16 | 11/18/16
GPO-030490 |  | 10/27/16 | DOUBLETREE BY HILTON MONROVIA PASADENA (WVI_DOUBLETREE BY [NAME]) | issued | No | 3100-2680-INLO-52035-000000-00000 | 1 | Hotel - DoubleTree | 638.28 | USD | 638.28 | [NAME] | [NAME] | 37790 | 09/14/16 | 11/14/16
 |  |  | DHL EXPRESS (USA) INC (WVI_DHL EXPRESS (USA) INC_2237) |  |  | 3100-2630-INLO-55070-000000-00000 | 1 | Express Envelope [NAME] | 65.31 | USD | 65.31 | [NAME] |  | ELA000357422 | 10/31/16 | 11/23/16
GPO-029340 |  | 09/30/16 | NOVAKOVIC ZORAN (WVI_NOVAKOVIC ZORAN_21868) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 1 | Consultancy services for MFI system implementation | 7623 | USD | 7623 | [NAME] | [NAME] | 103116 | 10/31/16 | 11/11/16
GPO-029340 |  | 09/30/16 | NOVAKOVIC ZORAN (WVI_NOVAKOVIC ZORAN_21868) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 2 | Hotel - Lodging | 1250.86 | USD | 1250.86 | [NAME] |  | 103116 | 10/31/16 | 11/11/16
GPO-029340 |  | 09/30/16 | NOVAKOVIC ZORAN (WVI_NOVAKOVIC ZORAN_21868) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 3 | Ground Transportation | 74.86 | USD | 74.86 | [NAME] |  | 103116 | 10/31/16 | 11/11/16
GPO-029340 |  | 09/30/16 | NOVAKOVIC ZORAN (WVI_NOVAKOVIC ZORAN_21868) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 4 | Other Travel Expenses | 274.82 | USD | 274.82 | [NAME] |  | 103116 | 10/31/16 | 11/11/16
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-52040-000000-00000 | 1 | Reimbursable Travel - FY16 | 2737.93 | USD | 2737.93 | [NAME] | [NAME] | 1 | 09/26/16 | 11/08/16
GPO-030854 |  | 11/03/16 | MATARAM PARTNERS (WVI_MATARAM [NAME]) | issued | No | 3100-2630-SAPO-57505-000000-00000 | 1 | Legal Fees - VisionFund Indonesia | 1650 | USD | 1650 | [NAME] | [NAME] | [NAME] | 11/01/16 | 11/08/16
[NAME] |  | 11/01/16 | INFOR US INC (WVI_INFOR US INC_23728) | issued | No | 3100-0001-INLO-17010-000000-00000 | 1 | Sun 6 Design & Build - VFI | 1470 | USD | 1470 | [NAME] | [NAME] | 20498899US0AB | 10/14/16 | 11/07/16
GPO-029580 |  | 10/10/16 | [NAME] (WVI_GUITY [NAME]) | issued | No | 3100-2630-LCRO-50030-000000-00000 | 1 | Consultancy - LACRO Finance Specialist | 2854.5 | USD | 2854.5 | [NAME] | Nino Gonjilashvili | 10201602 | 11/03/16 | 11/07/16
GPO-030228 |  | 10/24/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | cancelled | No | 3100-2645-INLO-52040-000000-00000 | 1 | Reimbursable Travel - FY16 | 2737.93 | USD | 2737.93 | [NAME] |  | 1 | 09/26/16 | 11/01/16
GPO-030228 |  | 10/24/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | cancelled | No | 3100-2645-INLO-52040-000000-00000 | 1 | Reimbursable Travel - FY16 | 2737.93 | USD | 2737.93 | [NAME] |  | 1 | 09/26/16 | 10/26/16
GPO-029580 |  | 10/10/16 | [NAME] (WVI_GUITY [NAME]) | issued | No | 3100-2630-LCRO-50030-000000-00000 | 1 | Consultancy - LACRO Finance Specialist | 2854.5 | USD | 2854.5 | [NAME] | Nino Gonjilashvili | 10201601 | 10/20/16 | 11/08/16
GPO-029580 |  | 10/10/16 | [NAME] (WVI_GUITY [NAME]) | issued | No | 3100-2630-LCRO-52040-000000-00000 | 2 | Reimbursable travel expenses | 158.46 | USD | 158.46 | [NAME] | Nino Gonjilashvili | 10201601 | 10/20/16 | 11/08/16
GPO-027530 |  | 09/14/16 | BANKBI UK LIMITED (WVI_BANKBI UK LIMITED_28389) | closed |  | 3100-2680-INLO-57525-000000-00000 | 1 | BankBI MFI Solution for Head Office | 12000 | GBP | 17196.9 | [NAME] | [NAME] | BBI040 | 09/15/16 | 09/15/16
GPO-027530 |  | 09/14/16 | BANKBI UK LIMITED (WVI_BANKBI UK LIMITED_28389) | closed |  | 3100-2680-INLO-57525-000000-00000 | 2 | BankBI [NAME] | 10000 | GBP | 14330.75 | [NAME] | [NAME] | BBI040 | 09/15/16 | 09/15/16
GPO-027530 |  | 09/14/16 | BANKBI UK LIMITED (WVI_BANKBI UK LIMITED_28389) | closed |  | 3100-2680-INLO-57525-000000-00000 | 3 | BankBI T24 Site SaaS | 18000 | GBP | 25795.36 | [NAME] | [NAME] | BBI040 | 09/15/16 | 09/15/16
GPO-022798 |  | 08/05/16 | HP INC (WVI_HP INC_3266) | closed | No | 3100-2620-INLO-51010-000000-00000 | 1 | HP CA09 Notebook battery part# E7U22AA | 43 | USD | 43 | [NAME] | Juana Crespo | 57609200 | 09/01/16 | 09/12/16
GPO-022798 |  | 08/05/16 | HP INC (WVI_HP INC_3266) | closed | No | 3100-2620-INLO-51010-000000-00000 | 2 | Estimated tax | 3.87 | USD | 3.87 | [NAME] | Juana Crespo | 57609200 | 09/01/16 | 09/12/16
GPO-017247 |  | 06/09/16 | EAGLE PRINT DYNAMICS (WVI_EAGLE PRINT DYNAMICS_13612) | closed | No | 3100-2620-INLO-51010-000000-00000 | 1 | Business Cards for Kevin Huttly - Programme Manager - 500 Cards | 36.27 | USD | 36.27 | [NAME] Marin | [NAME] | 440798 | 07/21/16 | 09/01/16
GPO-017247 |  | 06/09/16 | EAGLE PRINT DYNAMICS (WVI_EAGLE PRINT DYNAMICS_13612) | closed | No | 3100-2620-INLO-51010-000000-00000 | 3 | SALES TAX | 5.7 | USD | 5.7 | [NAME] Marin |  | 440798 | 07/21/16 | 09/01/16
GPO-017247 |  | 06/09/16 | EAGLE PRINT DYNAMICS (WVI_EAGLE PRINT DYNAMICS_13612) | closed | No | 2 Accounts: 7.13 USD (50%) WVI_Oracle, World Vision International.SEC Basic Education.Partnership Office.Supplies & Materials Under $5,000.SEC Basic Education.None,  Company: 2000, [NAME]: 2450, Location: INLO, Account: 51010, Function: 205014, Future: 00000 ; 7.13 USD (50%) WVI_Oracle, Vision Fund International.Vision Fund Administration.Partnership Office.Supplies & Materials Under $5,000.Default - None.None,  Company: 3100, [NAME]: 2620, Location: INLO, Account: 51010, Function: 000000, Future: 00000 | 4 | SHIPPING - COURIER | 14.26 | USD | 14.26 | [NAME] Marin | [NAME] | 440798 | 07/21/16 | 09/01/16
GPO-003873 |  | 10/16/15 | CCB TECHNOLOGY (WVI_CCB INC_2355) | closed | Yes | 3100-2645-INLO-51040-000000-00000 | 1 | [NAME] vs DC | 159 | USD | 159 | [NAME] | [NAME] | IN496171 | 08/25/16 | 08/26/16
 |  |  | CCB TECHNOLOGY (WVI_CCB INC_2355) |  | Yes | 3100-2645-INLO-51040-000000-00000 | 2 | GPO Processing Fee GPO-003873-INV-IN496171 | 7.95 | USD | 7.95 | [NAME] |  | IN496171 | 08/25/16 | 08/26/16
GPO-020459 |  | 07/13/16 | BANKBI UK LIMITED (WVI_BANKBI UK LIMITED_28389) | closed | Yes | 3100-2680-INLO-57525-000000-00000 | 1 | BankBI MFI Enterprise License | 220000 | GBP | 315276.58 | [NAME] | [NAME] | BBI017 | 07/15/16 | 07/15/16
GPO-020459 |  | 07/13/16 | BANKBI UK LIMITED (WVI_BANKBI UK LIMITED_28389) | closed | Yes | 3100-2680-INLO-57525-000000-00000 | 2 | BankBI Statement of Work 1 | 41600 | GBP | 59615.94 | [NAME] | [NAME] | BBI017 | 07/15/16 | 07/15/16
 |  |  | BANKBI UK LIMITED (WVI_BANKBI UK LIMITED_28389) |  | Yes | 3100-2680-INLO-57525-000000-00000 | 3 | GPO Processing Fee GPO-020459-INV-BBI017 | 13080 | GBP | 18744.63 | [NAME] |  | BBI017 | 07/15/16 | 07/15/16
GPO-012432 |  | 04/07/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | closed |  | 3100-2640-EUKO-51010-000000-00000 | 1 | [NAME] | 3625 | USD | 3625 | Esteban Solis | [NAME] | U011538WVUKAO | 04/06/16
GPO-012432 |  | 04/07/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | closed |  | 3100-2640-EUKO-51010-000000-00000 | 2 | SHIPPING - Inland Freight, Inspection, Consolidation, Packing, Documentation, & Courier Delivery to Client | 24.35 | USD | 24.35 | Esteban Solis | [NAME] | U011538WVUKAO | 04/06/16
GPO-012432 |  | 04/07/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | closed |  | 3100-2640-EUKO-51010-000000-00000 | 3 | SHIPPING - Insurance | 54.74 | USD | 54.74 | Esteban Solis | [NAME] | U011538WVUKAO | 04/06/16
 |  |  | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) |  |  | 3100-2640-EUKO-51010-000000-00000 | 4 | GPO Processing Fee GPO-012432 | 185.2 | USD | 185.2 | Esteban Solis |  | U011538WVUKAO | 04/06/16
GPO-006628 |  | 12/18/15 | HP INC UK LIMITED (WVI_HP INC UK LIMITED_27216) | closed |  | 3100-2630-EUKO-51020-000000-00000 | 1 | HP 3-Cell Battery for HP 820 Travel Laptop | 39 | USD | 39 | [NAME] | [NAME] | 5180621 | 01/04/16
GPO-006628 |  | 12/18/15 | HP INC UK LIMITED (WVI_HP INC UK LIMITED_27216) | closed |  | 3100-2630-EUKO-51020-000000-00000 | 2 | HP Ultra Slim Docking Station for HP 820 Travel Laptop | 113.3 | USD | 113.3 | [NAME] | [NAME] | 5180621 | 01/04/16
GPO-006628 |  | 12/18/15 | HP INC UK LIMITED (WVI_HP INC UK LIMITED_27216) | closed |  | 3100-2630-EUKO-51020-000000-00000 | 3 | Mouse HP USB Travel | 12.4 | USD | 12.4 | [NAME] | [NAME] | 5180621 | 01/04/16
GPO-006628 |  | 12/18/15 | HP INC UK LIMITED (WVI_HP INC UK LIMITED_27216) | closed |  | 3100-2630-EUKO-51020-000000-00000 | 4 | HP Monitor E232i 23 inch Display | 163 | USD | 163 | [NAME] | [NAME] | 5180621 | 01/04/16
GPO-006628 |  | 12/18/15 | HP INC UK LIMITED (WVI_HP INC UK LIMITED_27216) | closed |  | 3100-2630-EUKO-51020-000000-00000 | 5 | VAT CHARGE - 20% | 65.54 | USD | 65.54 | [NAME] |  | 5180621 | 01/04/16
 |  |  | HP INC UK LIMITED (WVI_HP INC UK LIMITED_27216) |  |  | 3100-2630-EUKO-51020-000000-00000 | 6 | Processing FEE GPO 006628 | 19.66 | USD | 19.66 | [NAME] |  | 5180621 | 01/04/16