Unleash the power of Fuzzy lookup in Excel

Learn: Fuzzy Lookup for Excel

Iss baar aapke saamne laaya hu ek behtarin tarika, Data ko Map karneka:

Agar aapke pass ek table ho, jisme naam kuch esse hai :

  1. The Mysore Paper Mills Ltd.
  2. Katha Mediatix India Ltd.
  3. Apeejay Business Centre.

Ye↑ Teen naam hosakta hai koi dusre Sheet/Table pe ho, jaha spelling mai gadbad ho, jaise ki:

  1. Mysore Mill Paper
  2. katha M India
  3. Apijay Businees Centre

Jisne bhi ye↑ likha hai, padhai likhai mai mun nahi laga hoga ya jaldbazi mai spelling mistake ki hogi.

Par problem aapke liye ye hai, ki inke pass vo number aane chaaiye, jo Table 1 mai hai.

Chaliye mai batata karta hu Microsoft k ek Free Add-In ki, jisska naam hai:

Fuzzy Lookup Add-In :

  • Aap Download kar sakte ho
  • Install kar sakte ho

Uske Website par puri jankari di gayi hai, kin Systems aur Softwares k sath ye chal sakta hai.

Chaliye, mai aapko dikhata hu ye kaam kaise karta hai.

Ek Panel aayega Right Side par, aur vo puchega:

  • Left Table?
  • Right Table?

Ab Table se mujhe yaad aaya ki, Pehle(1st) Table ko aapko ek Official Table ka darja dena hoga:

  • Data Choose kijiye
  • Insert→Table/Press Shortcut Key Ctrl + T
  • Press OK

Dusre Table par bhi vahi system dohray ↑

Ab ye dono(two) Table k rup mai aa chuke hai, abb ye faida aapko dekhne ko milega :

  • Table 3
  • Table 4

Aapke saamne do(two) panels mai aagye hai.

Note: Table 1 mai Lambe/Bade(big) Table ko rakhiye aur Table 2 mai Chote(small) Table ko.

Ab jo do(two) headings hai:

  1. Client Name
  2. Customer Name

Inke bich ek samband/relation establish karna chahunga:

  • Click kijiye ye  box par.

Subse ahem baat ye hai ki iski Similarity Threshold kya hogi?

  • Agar Bar ko pura 1 tak leke jaoge toh vahi data dikhaya jayega jo 1⇔1 Match karta ho.

But aisa nahi hai dosto, mai Excel ko choose karta hu jaha mujhe Answer chaiye:

  • Similarity Treshold ko karta hu 0.2.
  • Press Go.

Waah bhaiya!, kuch toh mere saamne nazar aaya hai :

  • Pehle 2 Column mai Orignal Data from Table 1
  • The Mysore Paper Mills Ltd. → Mysore Mill Paper, aachuka hai
  • Apeejay Business Centre → Apijay Businees Centre, bhi aaya hai
  • Katha Mediatix India Ltd. → ? nahi aaya.
  • Bharati Teletech → Bharti Teletech, jaha spelling alag alag hai vo match bhi hogya.

Agar aapko chahiye ki Katha Mediatix India Ltd. bhi aaye, toh uske liye :

  • 1st cell par jaaiye(Client Name).
  • Similarity Threshold kijiye 0.14
  • Click GO.

Waah bhaiya! Ye toh aur dept mai gaya aur Data ko Map kiya:

  • Katha Mediatix India Ltd. → Katha M Inida

Dosto, agar aap yehi kaam Manually karte, aapko shayad 1/2/3 din lagte the.

Agar ye Technique aapko aati hai dosto?

  • Aap ye kaam jarur karo
  • Boss ko jarur dikhao
  • Apne Team Members ko dikhao
  • Aur banjao Excel Superstar

Agle Naye(new) Tricks k intazaar mai:

  • Practice kare
  • Download kare

Toh Dosto, ye hai Microsoft ka Free Add-In Fuzzy Lookup.