주 콘텐츠로 건너뛰기
Microsoft Ignite에서 다음 소식을 놓치지 마세요.
Microsoft Ignite에서 다음 소식을 놓치지 마세요.Microsoft 기술을 만드는 사람들, 제품 및 전문 지식에 직접 액세스하세요. 질문하고 역량을 키우며 커뮤니티와 함께 배울 기회도 얻을 수 있습니다.
지금 등록
Microsoft
separator
https://store-images.s-microsoft.com/image/apps.16110.639b6014-315e-4b32-a8a7-785cabf25877.809a8377-036b-4da1-a45f-d050efa75323.9c70aae2-c920-45be-b95e-4b8bc4482d38.png

Fuzzy Lookup for Excel

SMALLPDF KENYA에 의해

(12 등급)

This Fuzzy Lookup add-in for excel allows user to perform fuzzy lookup and Fuzzy match up on excel

This fuzzy lookup for excel add-in allows for similarity text matching that allows you to perform fuzzy lookup and Fuzzy match up on excel.

The excel add-in works for both exact VLOOKUP as well as approximate match VLOOKUP.

To use the add-on you need an active subscription from the link on the Excel add-in side bar.

Excel Fuzzy Lookup Add-In is used to match similar, but not exactly matching data. This function is often used instead of VLOOKUP, when we want to compare two columns which have very similar data, but not exactly the same. As an output, Fuzzy Lookup returns a table of matched similar data in the chosen column.

In daily data manipulation, there is a common need to compare two same data sets where one of them comes from some external source and can be misspelled or typed incorrectly.

With the help of these add-in, you will see how to install Fuzzy Lookup Add-In, prepare data and create a Fuzzy Lookup, which can be very useful in data consolidation and save a lot of time.

The add-in works on mac book computers and uses more advanced algorithms.

It uses the Fuzzy String Matching algorithm to find the best matches for a given search term. It can also be used to find similar names to a given name, or to find the name of a person with a given name.

The tool can also be used for fuzzy matches in smart Lead distribution and management Software such as Lead angel and lean data for Lead assignment Rules.

The fuzzy lookup for excel add-in works well with no-code app building tools such as airtable, Zapier, Integromat, notion app Glide and Carrd.

Some of the additional features that the addon can perform are as listed below:

VLOOKUP with text

compare names similarity in excel sheets

VLOOKUP text contains

Compare address and names similarity

VLOOKUP approximate match text

VLOOKUP if cell contains a word within

앱 기능

이 앱을 사용하면
  • 문서를 읽거나 변경할 수 있음
  • 인터넷을 통해 데이터를 보낼 수 있음

한눈에 보기

https://store-images.s-microsoft.com/image/apps.52937.639b6014-315e-4b32-a8a7-785cabf25877.809a8377-036b-4da1-a45f-d050efa75323.f845645e-5ad3-4724-ad72-ce8e0247c66d.png
https://store-images.s-microsoft.com/image/apps.59252.639b6014-315e-4b32-a8a7-785cabf25877.809a8377-036b-4da1-a45f-d050efa75323.e7e21339-d91e-48fb-a9dc-365997e9e5a1.png
https://store-images.s-microsoft.com/image/apps.62885.639b6014-315e-4b32-a8a7-785cabf25877.809a8377-036b-4da1-a45f-d050efa75323.a115e49a-06eb-4800-b2aa-4c11fef68ce3.png
https://store-images.s-microsoft.com/image/apps.24701.639b6014-315e-4b32-a8a7-785cabf25877.809a8377-036b-4da1-a45f-d050efa75323.fdc95f41-369f-46e9-946b-d448fcb75246.png
https://store-images.s-microsoft.com/image/apps.16359.639b6014-315e-4b32-a8a7-785cabf25877.809a8377-036b-4da1-a45f-d050efa75323.552cf0a8-2dd8-401e-845c-5fae1cfa6c5e.png
한국어(대한민국)
개인정보처리방침 선택 옵트아웃 아이콘 개인 정보 선택 사항
소비자 상태 개인정보처리방침 사이트맵 Contact Us 개인정보처리방침 사용 약관 광고 정보 쿠키 관리