VLOOKUP VS INDEX & MATCH | DATA Matching

Joneye

Well-known Member
Joined
May 28, 2010
Messages
777
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
Hello all,

Using a mac so cannot post my data sadly. (Excel for Mac latest version).

Brief
* One workbook, data extract needs to be checked against another list. One source of data is from a CRM another from excel. All data has been cleaned and sat in two tabs.

Objective
* Check if items in list A match or are close to List B.

Example
* List A company name "Jon 123" (8000 indiviudal references)
* List B company name "Jon V1" (630 indiviudal references)

How on earch can i check list B against list A bringing in the cloest option for each line of A.

Help is appreciated.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Your remark "the closest option" makes it necesssary that you create here two small fake lists to illustrate this point.
 
Upvote 0
Your remark "the closest option" makes it necesssary that you create here two small fake lists to illustrate this point.

Im searching for a loook up funciton to match or get close to a company name, one database has JON XXX another due to input errors has JON YYY, simply looking for a fomula to return what is close so data can be sensor checked further.
 
Upvote 0
Im searching for a loook up funciton to match or get close to a company name, one database has JON XXX another due to input errors has JON YYY, simply looking for a fomula to return what is close so data can be sensor checked further.

I'm not going to create an example input and an associated output. The following will be as sketchy as your way with fake ranges...


=LOOKUP(9.99999999999999E+307,SEARCH("JON",$A$2:$A$100),$B$2:$B$100)
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top