Results 1 to 2 of 2

Thread: Match function not functioning

  1. #1

    Unhappy Match function not functioning

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to do some match + index functions to compare data from one worksheet to another. It appears that my MATCH function will only respond to cells which claim to hold text. As the data base has been put together by 'n' number of users, I have tried to cleared all formatting, then re-formatted the cells as numbers. A small range of cells are responding to the match...all others are returning N/A, when I can view the columns and see obvious matches. The small range of cells are registering 'true' to =istext() function. I tried formatting all cells as text, but they remain as numbers in response to =istext(). Any suggestions on how to get Match to work?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016


Posting Permissions

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