Spreadsheet: 791377d1660317420-excel-formula-for-pulling-specific-names-from-fields-sample-1-
Sheet: Sheet1

 | JOURNAL_LINE_DESCRIPTION | Vendor |  |  | Lookup
 | -MICROSOFT 9879232319A EA AGREEMENT | MICROSOFT |  |  | MICROSOFT |  | <--Type your lookup using all caps
 | -MICROSOFT CORP [PHONE] SUPPORT | MICROSOFT |  |  |  |  | as your data contains Caps and Proper
 | AAN-MICROSOFT 9879232319A EA AGREEMENT | MICROSOFT |  |  |  |  | Excel cannot match both so it must be
 | AAP-MICROSOFT CORP [PHONE] SUPPORT | MICROSOFT |  |  |  |  | one or the other.
 | E-Accrue Microsoft Corporation Azure Subscriptions May, June, July, Aug (D&A, Emtech, EA, RPA) | MICROSOFT
 | G-Accrue Microsoft Corporation Azure Subscriptions Azure for  May, June, July, Aug (CyberSec) | MICROSOFT |  |  |  |  | 1.  Type your vencor look up in F2 using all caps
 | A68-Microsoft [PHONE] Parts | MICROSOFT |  |  |  |  | 2.  On the data tab, select "Refresh All"
 | AAC-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Aug 2021 | MICROSOFT
 | AAE-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Aug 2021 | MICROSOFT
 | AAF-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Aug 2021 | MICROSOFT
 | AAG-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Aug 2021 | MICROSOFT
 | AAI-Microsoft Inv 9880141560A WinSvrDcCore - Aug 2021 | MICROSOFT
 | AAJ-Microsoft Inv 9880141560A WinSvrDcCore - Aug 2021 | MICROSOFT
 | AAL-Microsoft Inv 988179555 Virtual Machine FSv2 - Aug 2021 | MICROSOFT
 | AAO-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Aug 2021 | MICROSOFT
 | AAP-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Aug 2021 | MICROSOFT
 | AAR-Microsoft Inv 9880141556A O365 - Aug 2021 | MICROSOFT
 | AAT-Microsoft Inv 9880141556A O365 - Aug 2021 | MICROSOFT
 | AAU-Microsoft Inv 9880141556A O365 - Aug 2021 | MICROSOFT
 | AAW-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Aug 2021 | MICROSOFT
 | AHY-Microsoft Invoice [PHONE] (C52207). Terms Jun 21 - April 22 | MICROSOFT
 | AOF-Microsoft #9878834968A Enterprise System | MICROSOFT
 | AOQ-Microsoft Invoice [PHONE] | MICROSOFT
 | FF-Accrue Microsoft Corporation Azure Subscriptions May, June, July, Aug,[NAME] (D&A, Emtech, EA, RPA) | MICROSOFT
 | HH-Accrue Microsoft Corporation Azure Subscriptions Azure for  May, June, July, Aug, Sep (CyberSec) | MICROSOFT
 | FF-Accrue Microsoft Corporation Azure Subscriptions May, June, July, Aug,[NAME] (D&A, Emtech, EA, RPA) | MICROSOFT
 | HH-Accrue Microsoft Corporation Azure Subscriptions Azure for  May, June, July, Aug, Sep (CyberSec) | MICROSOFT
 | AA-Accrue Microsoft Corporation Azure Subscriptions May, June, July, Aug,Sep, [NAME] (D&A, Emtech, EA, RPA) | MICROSOFT
 | AAC-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Oct 2021 | MICROSOFT
 | AAE-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Oct 2021 | MICROSOFT
 | AAF-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Oct 2021 | MICROSOFT
 | AAG-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Oct 2021 | MICROSOFT
 | AAI-Microsoft Inv 9880141560A WinSvrDcCore - Oct 2021 | MICROSOFT
 | AAJ-Microsoft Inv 9880141560A WinSvrDcCore - Oct 2021 | MICROSOFT
 | AAL-Microsoft Inv 988179555 Virtual Machine [NAME] | MICROSOFT
 | AAO-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Oct 2021 | MICROSOFT
 | AAP-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Oct 2021 | MICROSOFT
 | AAR-Microsoft Inv 9880141556A O365 - Oct 2021 | MICROSOFT
 | AAT-Microsoft Inv 9880141556A O365 - Oct 2021 | MICROSOFT
 | AAU-Microsoft Inv 9880141556A O365 - Oct 2021 | MICROSOFT
 | AAW-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Oct 2021 | MICROSOFT
 | AIC-Microsoft Invoice [PHONE] (C52207). Terms Jun 21 - April 22 | MICROSOFT
 | ANU-Microsoft #9878834968A Enterprise System | MICROSOFT
 | AOG-Microsoft Invoice [PHONE] | MICROSOFT
 | CC-Accrue Microsoft Corporation Azure Subscriptions Azure for  May, June, July, Aug, Sep, [NAME] (CyberSec) | MICROSOFT
 | AA-Accrue Microsoft Corporation Azure Subscriptions May, June, July, Aug,Sep, [NAME] (D&A, Emtech, EA, RPA) | MICROSOFT
 | CC-Accrue Microsoft Corporation Azure Subscriptions Azure for  May, June, July, Aug, Sep, [NAME] (CyberSec) | MICROSOFT
 | AA-Accrue Microsoft Corporation Azure Subscriptions May-Nov(D&A, Emtech, EA, RPA) | MICROSOFT
 | AAC-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Nov 2021 | MICROSOFT
 | AAE-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Nov 2021 | MICROSOFT
 | AAF-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Nov 2021 | MICROSOFT
 | AAG-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Nov 2021 | MICROSOFT
 | AAI-Microsoft Inv 9880141560A WinSvrDcCore - Nov 2021 | MICROSOFT
 | AAJ-Microsoft Inv 9880141560A WinSvrDcCore - Nov 2021 | MICROSOFT
 | AAL-Microsoft Inv 988179555 Virtual Machine FSv2 - Nov 2021 | MICROSOFT
 | AAO-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Nov 2021 | MICROSOFT
 | AAP-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Nov 2021 | MICROSOFT
 | AAR-Microsoft Inv 9880141556A O365 - Nov 2021 | MICROSOFT
 | AAT-Microsoft Inv 9880141556A O365 - Nov 2021 | MICROSOFT
 | AAU-Microsoft Inv 9880141556A O365 - Nov 2021 | MICROSOFT
 | AAW-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Nov 2021 | MICROSOFT
 | AHH-Microsoft Invoice [PHONE] (C52207). Terms Jun 21 - April 22 | MICROSOFT
 | AOE-Microsoft Invoice [PHONE] | MICROSOFT
 | AOP-Microsoft #9878834968A Enterprise System | MICROSOFT
 | CC-Accrue Microsoft Corporation Azure Subscriptions Azure for  May-Nov (CyberSec) | MICROSOFT
 | AA-Accrue Microsoft Corporation Azure Subscriptions May-Nov(D&A, Emtech, EA, RPA) | MICROSOFT
 | CC-Accrue Microsoft Corporation Azure Subscriptions Azure for  May-Nov (CyberSec) | MICROSOFT
 | AAC-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Dec 2021 | MICROSOFT
 | AAE-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Dec 2021 | MICROSOFT
 | AAF-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Dec 2021 | MICROSOFT
 | AAG-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Dec 2021 | MICROSOFT
 | AAI-Microsoft Inv 9880141560A WinSvrDcCore - Dec 2021 | MICROSOFT
 | AAJ-Microsoft Inv 9880141560A WinSvrDcCore - Dec 2021 | MICROSOFT
 | AAL-Microsoft Inv 988179555 Virtual Machine FSv2 - Dec 2021 | MICROSOFT
 | AAO-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Dec 2021 | MICROSOFT
 | AAP-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Dec 2021 | MICROSOFT
 | AAR-Microsoft Inv 9880141556A O365 - Dec 2021 | MICROSOFT
 | AAT-Microsoft Inv 9880141556A O365 - Dec 2021 | MICROSOFT
 | AAU-Microsoft Inv 9880141556A O365 - Dec 2021 | MICROSOFT
 | AAW-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Dec 2021 | MICROSOFT
 | AA-Accrue Microsoft Corporation Azure Subscriptions May-Dec(D&A, Emtech, EA, RPA) | MICROSOFT
 | AC-Accrue Microsoft Corporation Azure Subscriptions Azure for  May-Dec (CyberSec) | MICROSOFT
 | AGX-Microsoft Invoice [PHONE] (C52207). Terms Jun 21 - April 22 | MICROSOFT
 | AK-Microsoft [PHONE] Dec-21 Expense | MICROSOFT
 | ANS-Microsoft Invoice [PHONE] | MICROSOFT
 | AOD-Microsoft #9878834968A Enterprise System | MICROSOFT
 | BH-Accrue Microsoft Corporation Azure Subscriptions ne,  May-Dec | MICROSOFT
 | CM-Microsoft #[PHONE] | MICROSOFT
 | AA-Accrue Microsoft Corporation Azure Subscriptions May-Dec(D&A, Emtech, EA, RPA) | MICROSOFT
 | AC-Accrue Microsoft Corporation Azure Subscriptions Azure for  May-Dec (CyberSec) | MICROSOFT
 | BH-Accrue Microsoft Corporation Azure Subscriptions ne,  May-Dec | MICROSOFT
 | AAC-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Jan 2022 | MICROSOFT
 | AAE-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Jan 2022 | MICROSOFT
 | AAF-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Jan 2022 | MICROSOFT
 | AAG-Microsoft Inv [PHONE] WinSvr, CoreCAL, WinE3 - Jan 2022 | MICROSOFT
 | AAI-Microsoft Inv 9880141560A WinSvrDcCore - Jan 2022 | MICROSOFT
 | AAJ-Microsoft Inv 988179555 Virtual Machine FSv2 - Rvsl of Sep-Dec expense | MICROSOFT
 | AAL-Microsoft Inv 988179555 Virtual Machine FSv2 - Jan 2022 | MICROSOFT
 | AAO-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Jan 2022 | MICROSOFT
 | AAP-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SubsVL - Jan 2022 | MICROSOFT
 | AAR-Microsoft Inv 9880141556A O365 - Jan 2022 | MICROSOFT
 | AAT-Microsoft Inv 9880141556A O365 - Jan 2022 | MICROSOFT
 | AAU-Microsoft Inv 9880141556A O365 - Jan 2022 | MICROSOFT
 | AAW-Microsoft Inv [PHONE] SQLSvrEntCore & SQLSvrStdCore ALNG SA MVL - Jan 2022 | MICROSOFT
 | ADX-Microsoft Invoice [PHONE] (C52207). Terms Jun 21 - April 22 | MICROSOFT
 | AE-Accrue Microsoft Corporation Azure Subscriptions May21-Jan22(D&A, Emtech, EA, RPA) | MICROSOFT
 | AEJ-Microsoft #[PHONE] Enterprise Services | MICROSOFT
 | AFX-Microsoft #[PHONE] CoreCal | MICROSOFT
 | AG-Accrue Microsoft Corporation Azure Subscriptions May21-Jan22(CyberSec) | MICROSOFT
 | AHG-MICROSOFT 9878834968A ENTERPRISE SYSTEM | MICROSOFT
 | ALA-Microsoft Invoice [PHONE] | MICROSOFT
 | BL-Accrue Azure Microsoft Corporation Azure Subscriptions  May21-Jan22 (9BJ/502-6048) | MICROSOFT
 | MICROSOFT CORPORATION-9880350555A | MICROSOFT
 | MICROSOFT CORPORATION-9880350555A | MICROSOFT
 | MICROSOFT CORPORATION-9880350555A | MICROSOFT
 | MICROSOFT CORPORATION-9880350555A | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT
 | MICROSOFT CORPORATION-[PHONE] | MICROSOFT