Fuzzy matching of some fields in Excel

Model: Huawei notebook matebook14

System: Windows 10

Specific method steps:

1. First, open Excel;

2. For example, B1, B2 and B3 are the full names of the company, while D1 is the abbreviation of the company;

3. Select cell E1, and then click Insert function in the formula toolbar;

Fuzzy matching of some fields in Excel

4. Then select the "lookup" function in the open box;

5. Finally, enter the same value of each input box as in the figure, and the "calculation result" will be displayed as the full name. Click OK.

Relevant data:

Fuzzy matching is a method used in some computer programs, especially those designed to automatically translate text between different languages. It is applicable to the case that the database used by the software does not exactly match the text.

Fuzzy matching of some fields in Excel

On the contrary, the database is looking for a close match, which is usually manually modified to check the acceptable accuracy. Most automatic translators simply compare the text with a previously translated database. This database is commonly referred to as translation memory (TM). Each new and confirmed translation is added to the database, which means that future translations are usually more accurate and faster. Generally, TM based translation applies to the whole sentence.

Favorite Posts

What year of education can Xuexin fi

At present, the self-study certificate can be checked on Xuexin online after 2001. Certifi

Xiaomi service framework has stopped

After the mobile phone system is updated, the service framework stops running. It may be t

How many stores can a Taobao member

Take Taobao version 9.17.0 as an example. Taobao rules stipulate that a person can registe

Welcome to call reminder service. Wh

Welcome to call reminder service means that when the mobile phone is turned off or not in

What does the customer identificatio

Internet banking customer identification number is a set of numbers generated by the busin

How to set Xiaomi AC2100 router

Setting method: 1. Connect to the default wireless signal of AC2100 Gigabit version of Xia

Press ESC to close