Forum Discussion

MT_15's avatar
MT_15
Copper Contributor
Dec 02, 2020
Solved

Using match function without the exact match

Hi all,   I have two worksheets containing names of the company. One has about 500k entries and is used as a master list. The other has 10k and is used as a reference. Now, I want to find out how m...
BI & Data Analysis
excel
Formulas and Functions
  • adversi's avatar
    adversi
    Dec 02, 2020

    MT_15 

    Is there any other fields you can use to distinguish the companies, phone #, web address, ID, etc.?

    The best alternative to a wildcard match is https://www.microsoft.com/en-us/download/details.aspx?id=15011

     

    This will allow you to control how exact the match need to be. If you have more than one column for the lookup to reference, this can increase the accuracy of the final pull. See below a screenshot test of how it works.

     

adversi's avatar
adversi
Iron Contributor
Dec 02, 2020

MT_15 

Is there any other fields you can use to distinguish the companies, phone #, web address, ID, etc.?

The best alternative to a wildcard match is https://www.microsoft.com/en-us/download/details.aspx?id=15011

 

This will allow you to control how exact the match need to be. If you have more than one column for the lookup to reference, this can increase the accuracy of the final pull. See below a screenshot test of how it works.