merge query not finding all matches

fehr56

New Member
Joined
Jun 19, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have 2 tables based on downloaded data from multiple sources. This is an automobile group consisting of 12 stores.
  1. Table 1 consists of data downloaded from 2 different sources. Three stores from 1 source and 9 stores from another source.
  2. Table 2 consists of data downloaded from a 3rd source. The same source for all stores.
  3. The data for the 3 stores finds matches while the data from the other 9 stores finds zero matches.
  4. Visually scanning the data clearly shows that there are some matches.
I have tried the merge with "fuzzy matches" turned on but then get many entries that are not actually matches. It is clear that Excel is not recognizing the data for the 9 stores. Does anyone know what I should be looking for in my data that is preventing Excel from seeing the matches?
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Radoslaw Poprawski

Active Member
Joined
Jun 19, 2021
Messages
326
Office Version
  1. 365
Platform
  1. Windows
Hello.
I just registered :)

I can try helping you out, but without seeing the data its hard to advice or direct you in any way.
Please, if you can provide some files.
 

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
2,298
Office Version
  1. 365
Platform
  1. Windows
First thing to look at is to make sure that the field(s) you are joining on have been set to the same "data type" in each of the queries.
 

Forum statistics

Threads
1,148,332
Messages
5,746,139
Members
423,994
Latest member
blzxatly

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
Top