Results 1 to 3 of 3

INDEX/MATCH with no match

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2008
    Location
    The Swamp
    MS-Off Ver
    2000 Pro
    Posts
    75

    INDEX/MATCH with no match

    I really appreciate all the help that I've received here.

    Using that help, I built my own index/match function. It works, unless there is no match, then I get the #NA result. I want it to return a blank.

    I tried the ISERROR and that converts it to true / false & it won't let me add "" to the end, like a general 'if' statement.

    Thanks
    Last edited by Georgia Golfer; 01-02-2009 at 05:55 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1