+ Reply to Thread
Results 1 to 3 of 3

Simple MATCH function error

  1. 06-16-2019, 06:23 PM #1
    jhb03190
    jhb03190 is offline
    Registered User
    Join Date
    06-13-2019
    Location
    USA
    MS-Off Ver
    Office 16
    Posts
    6

    Simple MATCH function error

    File has been attached. I'm trying to fix the MATCH formula on C72. Why does it not return a value? It must be a simple fix, maybe something to do with the text format, but I can't seem to figure it out...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-16-2019, 07:02 PM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Simple MATCH function error

    Simple fix....
    =MATCH(5101,A42:A74,0)

    Your formula was looking for the text "5101", which is not a match for the number 5101.

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  3. 06-16-2019, 07:30 PM #3
    jhb03190
    jhb03190 is offline
    Registered User
    Join Date
    06-13-2019
    Location
    USA
    MS-Off Ver
    Office 16
    Posts
    6

    Re: Simple MATCH function error

    Quote Originally Posted by Ron Coderre View Post
    Simple fix....
    =MATCH(5101,A42:A74,0)

    Your formula was looking for the text "5101", which is not a match for the number 5101.

    Does that help?
    Thank you. Excel newbie here..
    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. Simple AVERAGE function for numerical values returning #DIV/0 error.
    By jcoffman214 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2019, 12:55 PM
  2. [SOLVED] Function call on left-hand side error. Simple msgbox
    By DJDRU in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2016, 10:48 AM
  3. [SOLVED] error using string in simple function
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-02-2016, 06:08 PM
  4. [SOLVED] Vlookup to Pivot Table, using Match function, returns error if can't find match value
    By AndrewHowarth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2015, 12:10 AM
  5. Simple IF Function Error
    By joencrystal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2013, 12:38 PM
  6. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  7. Match Function Error
    By aki096 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2009, 05:22 PM

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