Spreadsheet: 491417d1480462725-vlookup-with-multiple-results-and-multiple-sheets-in-excel-stephen_c_example
Sheet: PO Lines

PO Number (Header) | PO Number and Line | Order Date (Header) | Supplier | [NAME] (Header) | GPO Processing Fee (Header) | Account | Line | Item | Order Transmission Status (Header) | Line Total | Currency | Reporting Total | Invoiced | Created By | Requested By (Header) | Need By | [NAME] | Invoice # | Invoice # | Invoice # | Invoice # | Invoice # | Invoice date
GPO-031840 |  | 11/17/16 | MCKEON KIMBERLEY ([NAME]) | issued | No | 3100-2620-INLO-57520-000000-00000 | 1 | Consultancy - [NAME] Tanzania technical agriculture advisory services | Sent via Email | 33000 | USD | 33000 | 29042.5 | [NAME] | [NAME] | 12/01/16 | partially_received
GPO-031706 |  | 11/15/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51110-000000-00000 | 1 | Apple 11.6" MacBook Air Notebook (P/N: MJVP2LL/A) | Sent via Email | 1112.5 | USD | 1112.5 | 0 | Cole Varvel | [NAME] | 11/21/16 | created
GPO-031706 |  | 11/15/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51110-000000-00000 | 2 | Precise Tactivo mini for iOS - SMART Card / Fingerprint Reader, USB (P/N: ALA 123 1014) | Sent via Email | 116.65 | USD | 116.65 | 0 | Cole Varvel | [NAME] | 11/21/16 | created
GPO-031706 |  | 11/15/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51110-000000-00000 | 3 | SHIPPING - Expedited Inland Freight to Consolidation Point | Sent via Email | 115 | USD | 115 | 0 | Cole Varvel | [NAME] | 11/21/16 | created
GPO-031706 |  | 11/15/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51110-000000-00000 | 4 | SHIPPING - Inspection, Consolidation, Export Packing (Repacking) | Sent via Email | 60 | USD | 60 | 0 | Cole Varvel | [NAME] | 11/21/16 | created
GPO-031706 |  | 11/15/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51110-000000-00000 | 5 | SHIPPING - Documentation & Expedited Courier Service Estimated) | Sent via Email | 44.3 | USD | 44.3 | 0 | Cole Varvel | [NAME] | 11/21/16 | created
GPO-031706 |  | 11/15/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51110-000000-00000 | 6 | SHIPPING - Insurance (min) | Sent via Email | 27.5 | USD | 27.5 | 0 | Cole Varvel | [NAME] | 11/21/16 | created
GPO-031620 |  | 11/14/16 | EUROPEAN MICROFINANCE PLATFORM (WVI_EUROPEAN [NAME] PLATFORM_27140) | issued | No | 3100-2640-EUKO-50211-000000-00000 | 1 | European Microfinance Platform - VFI Conference | Sent via Email | 625 | EUR | 693.9 | 0 | [NAME] | [NAME] | 12/31/16 | created
GPO-031065 |  | 11/07/16 | GARCIA BIBIANA ORTEGA (WVI_GARCIA BIBIANA ORTEGA_28616) | issued | No | 3100-2640-EUKO-57520-000000-00000 | 1 | VFI translation services - [NAME] | Sent via Email | 5000 | USD | 5000 | 0 | [NAME] | [NAME] | 07/26/17 | created
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-57520-000000-00000 | 1 | Consultancy - Donor landscaping assessment FY17 | Sent via Email | 33000 | USD | 33000 | 16500 | Cole Varvel | [NAME] | 11/07/16 | received
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-52040-000000-00000 | 2 | Reimbursable Travel - FY16 | Sent via Email | 3000 | USD | 3000 | 2737.93 | Cole Varvel | [NAME] | 09/30/16 | partially_received
[NAME] |  | 11/03/16 | [NAME] (WVI_RIPLEY DENNIS W_28732) | issued | No | 3100-2645-INLO-52040-000000-00000 | 3 | Reimbursable Travel - FY17 | Sent via Email | 1500 | USD | 1500 | 978.07 | Cole Varvel | [NAME] | 11/07/16 | partially_received
GPO-030859 |  | 11/03/16 | IVENER AND FULLMER LLP (WVI_IVENER AND [NAME]) | issued | No | 3100-2630-INLO-57505-000000-00000 | 1 | Legal Services (Immigration applications for Nino Gonjilasvili and Family) | Sent via Email | 7090 | USD | 7090 | 0 | [NAME] | [NAME] | 11/30/16 | created
GPO-030855 |  | 11/03/16 | VISTRA BV (WVI_VISTRA BV_22293) | issued | No | 3100-2630-EUKO-57525-000000-00000 | 1 | VFI - Vistra legal and accounting fees | Sent via Email | 6864 | EUR | 7620.74 | 0 | [NAME] | Kees Suijker | 11/11/16 | created
GPO-030854 |  | 11/03/16 | MATARAM PARTNERS (WVI_MATARAM [NAME]) | issued | No | 3100-2630-SAPO-57505-000000-00000 | 1 | Legal Fees - VisionFund Indonesia | Sent via Email | 19800 | USD | 19800 | 1 | [NAME] | [NAME] | 09/30/17 | received
[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 | Sent Manually | 1470 | USD | 1470 | 1470 | [NAME] | [NAME] | 06/30/17 | received
[NAME] |  | 11/01/16 | INFOR US INC (WVI_INFOR US INC_23728) | issued | No | 3100-0001-INLO-17010-000000-00000 | 2 | Sun 6 Design & Build - VFI | Sent Manually | 245390 | USD | 245390 | 0 | [NAME] | [NAME] | 06/30/17 | created
GPO-030499 |  | 10/27/16 | DOUBLETREE BY HILTON MONROVIA PASADENA (WVI_DOUBLETREE BY [NAME]) | issued | No | 3100-2630-INLO-52035-000000-00000 | 1 | Hotel - DoubleTree | Sent via Email | 5000 | USD | 5000 | 0 | [NAME] | [NAME] | 09/30/17 | created
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 | Sent via Email | 5000 | USD | 5000 | 638.28 | Cole Varvel | [NAME] | 09/30/17 | partially_received
GPO-030072 |  | 10/20/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51010-000000-00000 | 1 | Apple 11.6" MacBook Air Notebook - P/N: MJVP2LL/A | Sent via Email | 1112.5 | USD | 1112.5 | 0 | [NAME] | [NAME] | 10/28/16 | created
GPO-030072 |  | 10/20/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51010-000000-00000 | 2 | Precise Tactivo mini for iOS - SMART Card / Fingerprint Reader, USB - P/N: ALA 123 1014 | Sent via Email | 116.65 | USD | 116.65 | 0 | [NAME] | [NAME] | 10/28/16 | created
GPO-030072 |  | 10/20/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51010-000000-00000 | 3 | SHIPPING - Expedited Inland Freight to Consolidation Point | Sent via Email | 115 | USD | 115 | 0 | [NAME] | [NAME] | 10/28/16 | created
GPO-030072 |  | 10/20/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51010-000000-00000 | 4 | SHIPPING - Inspection, Consolidation & Export Packing | Sent via Email | 60 | USD | 60 | 0 | [NAME] | [NAME] | 10/28/16 | created
GPO-030072 |  | 10/20/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51010-000000-00000 | 5 | SHIPPING - Documentation & Expedited Courier Service Estimated | Sent via Email | 44.3 | USD | 44.3 | 0 | [NAME] | [NAME] | 10/28/16 | created
GPO-030072 |  | 10/20/16 | INTERNATIONAL PROCUREMENT AGENCY (WVI_INTERNATIONAL PROCUREMENT AGENCY_13673) | issued | Yes | 3100-2680-INLO-51010-000000-00000 | 6 | SHIPPING - Insurance | Sent via Email | 27.5 | USD | 27.5 | 0 | [NAME] | [NAME] | 10/28/16 | created
GPO-029762 |  | 10/14/16 | DE VERE VENUES GROUP LTD (WVI_DE VERE VENUES GROUP LTD_21075) | issued | No | 3100-2620-EUKO-50211-000000-00000 | 1 | VFI Strategy Conference - Hartsfield Manor | Sent via Email | 18000 | GBP | 25795.36 | 0 | Cole Varvel | [NAME] | 11/04/16 | created
GPO-029614 |  | 10/10/16 | MOO INC (WVI_MOO INC_27254) | issued | No | 3100-2640-INLO-57525-000000-00000 | 1 | Business Cards | Sent via Email | 3000 | USD | 3000 | 0 | [NAME] | [NAME] | 09/30/18 | created
GPO-029613 |  | 10/10/16 | MOO PRINT LIMITED (WVI_MOO PRINT LIMITED_27597) | issued |  | 3100-2640-INLO-57525-000000-00000 | 1 | Business Cards | Sent via Email | 2500 | GBP | 3582.69 | 0 | [NAME] | [NAME] | 09/30/18 | created
GPO-029580 |  | 10/10/16 | [NAME] (WVI_GUITY [NAME]) | issued | No | 3100-2630-LCRO-50030-000000-00000 | 1 | Consultancy - LACRO Finance Specialist | Sent via Email | 20500.5 | USD | 20500.5 | 22 | [NAME] | Nino Gonjilashvili | 01/19/17 | partially_received
GPO-029580 |  | 10/10/16 | [NAME] (WVI_GUITY [NAME]) | issued | No | 3100-2630-LCRO-52030-000000-00000 | 2 | Reimbursable travel expenses | Sent via Email | 2800 | USD | 2800 | 0 | [NAME] | Nino Gonjilashvili | 01/19/17 | created
GPO-029580 |  | 10/10/16 | [NAME] (WVI_GUITY [NAME]) | issued | No | 3100-2630-LCRO-52040-000000-00000 | 3 | Reimbursable travel expenses | Sent via Email | 450 | USD | 450 | 0 | [NAME] | Nino Gonjilashvili | 01/19/17 | created
GPO-029580 |  | 10/10/16 | [NAME] (WVI_GUITY [NAME]) | issued | No | 3100-2630-LCRO-52040-000000-00000 | 4 | Reimbursable travel expenses | Sent via Email | 200 | USD | 200 | 158.46 | [NAME] | Nino Gonjilashvili | 01/19/17 | partially_received
GPO-029476 |  | 10/06/16 | SILLER ARTURO SUAREZ (WVI_SILLER ARTURO SUAREZ_25894) | issued | No | 3100-2680-LCRO-50030-000000-00000 | 1 | Consultancy C&P LCRO | Sent via Email | 12000 | USD | 12000 | 0 | Cole Varvel | [NAME] | 12/31/16 | created
GPO-029476 |  | 10/06/16 | SILLER ARTURO SUAREZ (WVI_SILLER ARTURO SUAREZ_25894) | issued | No | 3100-2680-LCRO-52030-000000-00000 | 2 | Airfare | Sent via Email | 2700 | USD | 2700 | 0 | Cole Varvel | [NAME] | 12/31/16 | created
GPO-029476 |  | 10/06/16 | SILLER ARTURO SUAREZ (WVI_SILLER ARTURO SUAREZ_25894) | issued | No | 3100-2680-LCRO-52035-000000-00000 | 3 | Hotel | Sent via Email | 1700 | USD | 1700 | 0 | Cole Varvel | [NAME] | 12/31/16 | created
GPO-029476 |  | 10/06/16 | SILLER ARTURO SUAREZ (WVI_SILLER ARTURO SUAREZ_25894) | issued | No | 3100-2680-LCRO-52040-000000-00000 | 4 | Other Travel | Sent via Email | 600 | USD | 600 | 0 | Cole Varvel | [NAME] | 12/31/16 | created
GPO-029476 |  | 10/06/16 | SILLER ARTURO SUAREZ (WVI_SILLER ARTURO SUAREZ_25894) | issued | No | 3100-2680-LCRO-52045-000000-00000 | 5 | Ground Transportation | Sent via Email | 400 | USD | 400 | 0 | Cole Varvel | [NAME] | 12/31/16 | created
GPO-029444 |  | 10/05/16 | MIRANDA BARHAM LTD (WVI_MIRANDA BARHAM LTD_22054) | issued | No | 3100-2640-EUKO-57520-000000-00000 | 1 | Consultancy - Global Media Relations | Sent via Email | 16200 | GBP | 23215.82 | 0 | Cole Varvel | [NAME] | 09/30/17 | created
GPO-029425 |  | 10/05/16 | HARMONY MARKETING GROUP (WVI_HARMONY MARKETING GROUP_18546) | issued | No | 3100-2645-INLO-57520-000000-00000 | 1 | Consultancy Fundraising | Sent via Email | 6780 | USD | 6780 | 0 | [NAME] | [NAME] | 12/31/16 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-50030-000000-00000 | 1 | Consultancy C&P Implementations | Sent via Email | 120000 | USD | 120000 | 0 | [NAME] | [NAME] | 09/30/17 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-52030-000000-00000 | 2 | Airfare | Sent via Email | 22000 | USD | 22000 | 0 | [NAME] | [NAME] | 09/30/17 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-52035-000000-00000 | 3 | Hotel | Sent via Email | 4500 | USD | 4500 | 0 | [NAME] | [NAME] | 09/30/17 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-52040-000000-00000 | 4 | Other travel | Sent via Email | 1600 | USD | 1600 | 0 | [NAME] | [NAME] | 09/30/17 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-52045-000000-00000 | 5 | Ground Transportation | Sent via Email | 800 | USD | 800 | 0 | [NAME] | [NAME] | 09/30/17 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-50030-000000-00000 | 6 | Consultancy C&P Implementations | Sent via Email | 80000 | USD | 80000 | 0 | [NAME] | [NAME] | 05/31/18 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-52030-000000-00000 | 7 | Airfare | Sent via Email | 15000 | USD | 15000 | 0 | [NAME] | [NAME] | 05/31/18 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-52035-000000-00000 | 8 | Hotel | Sent via Email | 3000 | USD | 3000 | 0 | [NAME] | [NAME] | 05/31/18 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-52040-000000-00000 | 9 | Other travel | Sent via Email | 1000 | USD | 1000 | 0 | [NAME] | [NAME] | 05/31/18 | created
GPO-029357 |  | 10/03/16 | SALORA LLC (WVI_SALORA [NAME]) | issued | No | 3100-2680-INLO-52045-000000-00000 | 10 | Ground Transportation | Sent via Email | 550 | USD | 550 | 0 | [NAME] | [NAME] | 05/31/18 | created
GPO-029346 |  | 10/02/16 | [NAME] (WVI_BNK SYS COM LTD_27703) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 1 | Consultancy T24 | Sent via Email | 50000 | USD | 50000 | 0 | [NAME] | [NAME] | 02/28/17 | created
GPO-029346 |  | 10/02/16 | [NAME] (WVI_BNK SYS COM LTD_27703) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 2 | Airfare Expense | Sent via Email | 7000 | USD | 7000 | 0 | [NAME] | [NAME] | 02/28/17 | created
GPO-029346 |  | 10/02/16 | [NAME] (WVI_BNK SYS COM LTD_27703) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 3 | Hotel Expenses | Sent via Email | 2400 | USD | 2400 | 0 | [NAME] | [NAME] | 02/28/17 | created
GPO-029346 |  | 10/02/16 | [NAME] (WVI_BNK SYS COM LTD_27703) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 4 | Other Travel | Sent via Email | 1500 | USD | 1500 | 0 | [NAME] | [NAME] | 02/28/17 | created
GPO-029346 |  | 10/02/16 | [NAME] (WVI_BNK SYS COM LTD_27703) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 5 | Ground Transportation | Sent via Email | 700 | USD | 700 | 0 | [NAME] | [NAME] | 02/28/17 | created
GPO-029342 |  | 09/30/16 | [NAME] (WVI_BARKER ROGER_28093) | issued | No | 3100-2622-EUKO-57520-000000-00000 | 1 | Consultancy - MFI Governance Training | Sent via Email | 9100 | GBP | 13040.99 | 0 | Davie Kombanie | [NAME] withams | 07/31/17 | created
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 | Sent Manually | 22869 | USD | 22869 | 1 | Cole Varvel | [NAME] | 12/31/16 | received
GPO-029340 |  | 09/30/16 | NOVAKOVIC ZORAN (WVI_NOVAKOVIC ZORAN_21868) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 2 | Airfare - Transporation | Sent Manually | 6000 | USD | 6000 | 0 | [NAME] | [NAME] | 12/31/16 | partially_received
GPO-029340 |  | 09/30/16 | NOVAKOVIC ZORAN (WVI_NOVAKOVIC ZORAN_21868) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 3 | Hotel - Lodging | Sent Manually | 2200 | USD | 2200 | 1250.86 | [NAME] | [NAME] | 12/31/16 | partially_received
GPO-029340 |  | 09/30/16 | NOVAKOVIC ZORAN (WVI_NOVAKOVIC ZORAN_21868) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 4 | Other Travel Expenses | Sent Manually | 1000 | USD | 1000 | 274.82 | [NAME] | [NAME] | 12/31/16 | partially_received
GPO-029340 |  | 09/30/16 | NOVAKOVIC ZORAN (WVI_NOVAKOVIC ZORAN_21868) | issued | No | 3100-2680-MEEO-50030-000000-00000 | 5 | Ground Transportation | Sent Manually | 150 | USD | 150 | 74.86 | [NAME] | [NAME] | 12/31/16 | partially_received
GPO-029339 |  | 09/30/16 | [NAME] (WVI_NAYAGAM PRINCE_27625) | issued | No | 3100-2680-INLO-57520-000000-00000 | 1 | Consultancy - SME VisionFund Lanka | Sent via Email | 3750 | USD | 3750 | 0 | Cole Varvel | [NAME] | 12/31/16 | created
GPO-017302 |  | 06/09/16 | KPMG LLP (WVI_KPMG LLP_2847) | issued | Yes | 3100-2630-INLO-57520-000000-00000 | 1 | VisionFund International Financial Statement Audit Services -  Audit of Consolidated Financial Statements and Related Notes for FY17 | Sent Manually | 171500 | USD | 171500 | 0 | [NAME] | [NAME] | 09/30/17 | created
GPO-017302 |  | 06/09/16 | KPMG LLP (WVI_KPMG LLP_2847) | issued | Yes | 3100-2630-INLO-57520-000000-00000 | 2 | VisionFund International Financial Statement Audit Services -  Audit of Consolidated Financial Statements and Related Notes for FY18 | Sent Manually | 178600 | USD | 178600 | 0 | [NAME] | [NAME] | 09/30/18 | created
GPO-017302 |  | 06/09/16 | KPMG LLP (WVI_KPMG LLP_2847) | issued | Yes | 3100-2630-INLO-57520-000000-00000 | 3 | VisionFund International Financial Statement Audit Services -  Audit of Consolidated Financial Statements and Related Notes for FY19 | Sent Manually | 184000 | USD | 184000 | 0 | [NAME] | [NAME] | 09/30/19 | created
GPO-017302 |  | 06/09/16 | KPMG LLP (WVI_KPMG LLP_2847) | issued | Yes | 3100-2630-INLO-57520-000000-00000 | 4 | VisionFund International Financial Statement Audit Services -  Audit of Consolidated Financial Statements and Related Notes for FY20 | Sent Manually | 189500 | USD | 189500 | 0 | [NAME] | [NAME] | 09/30/20 | created
GPO-017302 |  | 06/09/16 | KPMG LLP (WVI_KPMG LLP_2847) | issued | Yes | 3100-2630-INLO-57520-000000-00000 | 5 | VisionFund International Financial Statement Audit Services -  Audit of Consolidated Financial Statements and Related Notes for FY21 | Sent Manually | 189500 | USD | 189500 | 0 | [NAME] | [NAME] | 09/30/21 | created