+ Reply to Thread
Results 1 to 3 of 3

IF ISNA function

  1. #1
    Registered User
    Join Date
    06-09-2009
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2003
    Posts
    91

    IF ISNA function

    I need help working out this function.

    Cols B to J need to look at correspondeing Cols L to T

    Col B looks at Col L
    Col C looks at Col M
    Col D looks at col N
    and so on

    I need the following to occur

    COl B needs to look at Col L and then goto the Lookup table LEP and if there is a corresponding entry, key that in but if not then ABNI. BUT,,,, If ColB looks up Col L and there is no entry at all, i need it to stay blank.

    The first 12 lines of my spreadsheet show how i would like it to look.

    Every time i create my formula i keep getting ABNI to appear, even when the corresponding col has no entry. If there is not entry i need it to stay blank.
    Attached Files Attached Files
    Last edited by ssdsibes; 05-23-2011 at 02:58 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,111

    Re: IF ISNA function

    You mean like this?

    =IF(L2="","",IF(ISNA(VLOOKUP(L2,LEP!$A$1:$B$71,2,FALSE)),"ABNI",(VLOOKUP(L2,LEP!$A$1:$B$71,2,FALSE))))
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    06-09-2009
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2003
    Posts
    91

    Re: IF ISNA function

    Perfect, exactly what i mean.

+ 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