Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: UNRELIABLE DATA MATCHES

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Thanks!
    Adam

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •