+ Reply to Thread
Results 1 to 7 of 7

lookup with #N/A

  1. #1
    Registered User
    Join Date
    08-05-2011
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2003
    Posts
    8

    lookup with #N/A

    I am using the following formula =IF(ISBLANK(C5),"",LOOKUP(C5,$M$47:$M$80,$N$47:$N$80)). Works good except on the cells that are blank I get #N/A. For example if I point the formula to c6 and it blank it returns the error.

    Thank for helping.

  2. #2
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: lookup with #N/A

    keep your cursor on the c6 and press delete. there may some unseen values in this cell


    If your problem is not solved, upload a sample workbook with sample data and your desired results

    In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: lookup with #N/A

    Hello & Welcome to the Board,

    Maybe try...

    =IF(ISNA(LOOKUP(C5,$M$47:$M$80,$N$47:$N$80)),"",LOOKUP(C5,$M$47:$M$80,$N$47:$N$80))
    HTH
    Regards, Jeff

  4. #4
    Registered User
    Join Date
    08-05-2011
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: lookup with #N/A

    No hidden values but I do have a formula, the result of the formula is nothing (a blank cell).

  5. #5
    Registered User
    Join Date
    08-05-2011
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: lookup with #N/A

    Works great, thank for helping.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: lookup with #N/A

    You're welcome and glad it worked for you

  7. #7
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: lookup with #N/A

    Quote Originally Posted by dcoleman5
    No hidden values but I do have a formula, the result of the formula is nothing (a blank cell).
    For the sake of explanation...

    ISBLANK treats Null Strings ("") as non-blank (ie FALSE), COUNTBLANK does not ... a true Blank is a cell devoid of all content, a Null String is a 0 Length Text string.

    Please Login or Register  to view this content.
    Another method of the same would be:

    Please Login or Register  to view this content.

+ Reply to Thread

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