Results 1 to 5 of 5

Having a problem with ISNA

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Having a problem with ISNA

    I want to get rid of #N/A from a formula. I can get the formual to eliminate the #N/A but then it won't return a value when it should.

    This formula works.

    =VLOOKUP($B50,INDIRECT("'"&$B$2&"'!$B$2:$K$43"),3,FALSE)
    This is the formula I tried with ISNA.

    =IF(ISNA(VLOOKUP($B51,INDIRECT("'"&$B$2&"'!$B$2:$K$43"),3,FALSE)),"",(VLOOKUP($B51,INDIRECT(""&$B$2&"'!$B$2:$K$43"),3,FALSE)))

    Jim O
    Last edited by JO505; 06-05-2011 at 03:36 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