+ Reply to Thread
Results 1 to 2 of 2

Nested IF(ISNA) Statements - Multiple Sheets

  1. #1
    Registered User
    Join Date
    08-18-2013
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    1

    Nested IF(ISNA) Statements - Multiple Sheets

    Good Afternoon All,

    I've been trying to solve this formula problem. I am using serval vlookups across 3 different sheets in one workbook. The first part of the formula works and results in a blank cell. However, the 2nd part of the formula should display the date from one of the worksheets, but only displays False. I can't fiqure out how to fix it. Please see formula below. Thanks for your help.

    =IF(ISNA(VLOOKUP(B8,Exported!E:F,2,0)),IF(ISNA(VLOOKUP(B8,'Exported 1'!F:G,2,0)),IF(ISNA(VLOOKUP(B8,'Exported 2'!F:G,2,0)),"",VLOOKUP(B8,Exported!E:F,2,0))))


    Thanks Again!!!

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Nested IF(ISNA) Statements - Multiple Sheets

    As you are using Excel 2010:
    =IFERROR(IFERROR(IFERROR(VLOOKUP(B8,Exported!E:F,2,0),VLOOKUP(B8,'Exported 1'!F:G,2,0)),VLOOKUP(B8,'Exported 2'!F:G,2,0)),"")
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

+ 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. Adding ISNA to long nested IF statements with vlookups
    By vgately99 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-07-2013, 02:59 PM
  2. Multiple Nested IF Statements
    By rlsublime in forum Excel General
    Replies: 1
    Last Post: 11-15-2012, 02:01 PM
  3. Replies: 4
    Last Post: 07-17-2012, 10:25 PM
  4. Multiple nested IF statements and AND statements
    By TonyGetz in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 03:07 AM
  5. Replies: 12
    Last Post: 05-15-2009, 08:38 AM

Tags for this Thread

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