UNRELIABLE DATA MATCHES

QUADBIKER1 · Apr 15th, 2002, 01:56 PM

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?

Ricky Morris · Apr 15th, 2002, 02:15 PM

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)

Asala42 · Apr 15th, 2002, 02:18 PM

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

Aladin Akyurek · Apr 15th, 2002, 02:31 PM

Quote:

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

Asala42 · Apr 15th, 2002, 02:40 PM

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

Thanks!
Adam

Apr 15th, 2002, 02:15 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	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) __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 01:56 PM	#1
QUADBIKER1 New Member Join Date: Apr 2002 Posts: 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?

Apr 15th, 2002, 02:18 PM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	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

Apr 15th, 2002, 02:40 PM	#5
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	You know I never really thought about it, Aladin - good call. I'll use that from now on. Thanks! Adam