+ Reply to Thread
Results 1 to 7 of 7

ISNA formula help

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    32

    ISNA formula help

    Hi,

    Please help me with a formula for the below
    I have vlookup in Col A, B and C, out of three col I can have data in any one column and I want to have that data in Col D

    I tried this =IF(ISNA(A1),B1,IF(ISNA(B1),C1,IF(ISNA(C1),A1,C1))) but not working.

    Thanks,

    Akshay

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: ISNA formula help

    Post a small sample file showing expected results form all conditions For example. if A! and B1 error then D1 will error. So what are valid conditions In A, B and C?

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: ISNA formula help

    Try

    in D1
    =IF(NOT(ISNA(A1)),A1,IF(NOT(ISNA(B1)),B1,IF(NOT(ISNA(C1)),C1)))
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    03-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: ISNA formula help

    Thanks, this works out perfectly fine

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: ISNA formula help

    What type of data does the formula normally return? Is it text? Numbers? Could be both? Something else?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Registered User
    Join Date
    03-08-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: ISNA formula help

    Formula returns numbers

  7. #7
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: ISNA formula help

    Ok, assuming that at least one cell will always contain a number...

    Data Range
    A
    B
    C
    D
    1
    100
    #N/A
    #N/A
    100
    2
    #N/A
    500
    #N/A
    500
    3
    #N/A
    #N/A
    750
    750
    4
    ------
    ------
    ------
    ------


    This formula entered in D1 and copied down:

    =LOOKUP(1E100,A1:C1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF + OR formula using ISNA
    By waternut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2013, 10:20 AM
  2. How do I add ISNA to this formula?
    By Nobranalon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2013, 07:06 PM
  3. How do I add ISNA to this formula?
    By Nobranalon in forum Excel General
    Replies: 3
    Last Post: 01-24-2013, 07:06 PM
  4. [SOLVED] ISNA formula help
    By Darrenh1238 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2012, 07:03 AM
  5. Excel 2007 : If isna formula
    By glens73 in forum Excel General
    Replies: 3
    Last Post: 10-25-2011, 01:16 PM
  6. Need help with ISNA formula
    By obionenairobi in forum Excel General
    Replies: 7
    Last Post: 02-22-2011, 09:06 AM
  7. How do I use ISNA on this formula
    By amario in forum Excel Formulas & Functions
    Replies: 53
    Last Post: 09-07-2005, 12:05 AM

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