+ Reply to Thread
Results 1 to 3 of 3

Match Function mystery

  1. 03-05-2021, 10:06 AM #1
    JyothiGrace
    JyothiGrace is offline
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    144

    Match Function mystery

    Morning,

    I have been using the match function successfully for the past year but racking my brain trying to find error on attached sheet.

    Reference value in Column A. Zip codes listed in F2 & F3 should show matched row number in G2 & G3............?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-05-2021, 10:12 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Match Function mystery

    When you hover over the warning icon, you will get your answer.
    Text and numbers do not match

    2021-03-05_8-10-11.jpg

    You see I have a zero in I2, copy it and then select F2:f3 and paste special Add, to turn them back into numbers.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 03-07-2021, 10:34 PM #3
    JyothiGrace
    JyothiGrace is offline
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    144

    Re: Match Function mystery

    Yep.....that was it!

    Mystery solved
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] how to use match function and get result as ture if condition is true then match function
    By jd16 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-09-2020, 10:41 AM
  2. Excel Cell Reference Mystery: - function name change?
    By ian128 in forum Excel General
    Replies: 3
    Last Post: 11-29-2013, 06:34 PM
  3. how to use match function or count if function to match two columns of text.
    By ram09 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-26-2012, 02:21 PM
  4. Function MYSTERY!! Need help to extract text strings separated by commas and spaces!
    By VB15 in forum Excel General
    Replies: 4
    Last Post: 06-21-2012, 08:17 PM
  5. [SOLVED] MYSTERY!!
    By WhytheQ in forum Excel General
    Replies: 2
    Last Post: 06-20-2006, 06:00 AM
  6. [SOLVED] Border Mystery?
    By Josh Sale in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-16-2005, 05:06 PM
  7. [SOLVED] mystery function called 'TABLE'
    By SongBear in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-07-2005, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1