UNRELIABLE DATA MATCHES

QUADBIKER1

New Member
Joined
Apr 14, 2002
Messages
1
I HAVE A COLUMN OF 1000 CELLS WITH SERIAL CODES IN THEM (18 DIGIT ALPHANUMERIC). IN ANOTHER COLUMN I WILL ADD SAY 25O CODES THAT I KNOW APPEAR IN THE FIRST AND ASK THE TWO TO COMPARE AND HIGHLIGHT EXACT MATCHES - THIS WORKS TO A POINT BUT IT ALSO HIGHLIGHTS ALL OTHERS THAT END WITHIN 100 OF THE ORIGINAL NUMBER - HOW CAN I GET EXACT MATCH ONLY?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Make sure you're using a match type of zero to find an exact match. Your formula should look as follows:

MATCH(lookup_value,lookup_array,0)
 
Upvote 0
Hiya,

- you might want to give your Caps Lock key a friendly tap to turn it off.

If you're using VLOOKUP, you want to include a 4th FALSE argument for an exact match.
If you're using MATCH - make sure your Match_type argument is set to 0.

Hope that helps
Adam
 
Upvote 0
On 2002-04-15 13:18, Asala42 wrote:
Hiya,

- you might want to give your Caps Lock key a friendly tap to turn it off.

If you're using VLOOKUP, you want to include a 4th FALSE argument for an exact match.
If you're using MATCH - make sure your Match_type argument is set to 0.

Hope that helps
Adam

Adam,

Why not use 0 also in VLOOKUP instead of FALSE?

Aladin
 
Upvote 0
You know I never really thought about it, Aladin - good call. I'll use that from now on.

Thanks!
Adam
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

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