Results 1 to 8 of 8

Invalid nested formula syntax

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2017
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 2007
    Posts
    53

    Invalid nested formula syntax

    Hello all, I am trying to rework a formula that I was helped with on here before. The current formula is searching for a unique ID on 4 different tabs. I need to add (1) additional tab to the formula but it is giving me an error.

    Here is the current formula:
    =IFERROR(IFERROR(INDEX(Tab1!A:A,MATCH($E2,Tab1!$E:$E,0)), IFERROR(INDEX(Tab2!A:A,MATCH($E2,Tab2!$E:$E,0)), IFERROR(INDEX(Tab3!E:E,MATCH($E2,Tab3!$E:$E,0)), IFERROR(INDEX(Tab4!A:A,MATCH($E2,Tab4!$E:$E,0))))),"")

    Here is my adjusted formula:
    =IFERROR(IFERROR(INDEX(Tab1!A:A,MATCH($E2,Tab1!$E:$E,0)), IFERROR(INDEX(Tab2!A:A,MATCH($E2,Tab2!$E:$E,0)), IFERROR(INDEX(Tab3!E:E,MATCH($E2,Tab3!$E:$E,0)), IFERROR(INDEX(Tab4!A:A,MATCH($E2,Tab4!$E:$E,0)), IFERROR(INDEX(Tab5!A:A,MATCH($E2,Tab5!$E:$E,0))))),"")

    I didn't do anything but add a separate tab to the list and now it is giving me this error:
    You've entered too few Arguments for this function.

    Any ideas what I am missing?

    Thanks for the help!

    Nathan
    Last edited by Irukandji81; 11-10-2017 at 07:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] FORMULA Remove #NUM error not using IFERROR OR IS ERROR
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-03-2017, 04:22 PM
  2. Formula error or data link error
    By sctr in forum Excel General
    Replies: 4
    Last Post: 09-19-2016, 09:15 AM
  3. [SOLVED] Inputbox error message. Formula you typed contains an error.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2013, 02:25 PM
  4. Excel 2007 : Formula error:bring up an #VALUE! Error.
    By burner007 in forum Excel General
    Replies: 3
    Last Post: 06-20-2011, 06:10 AM
  5. Formula Error-Error Message
    By Paige in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2006, 04:15 PM
  6. Replies: 4
    Last Post: 03-24-2006, 07:20 AM
  7. Error values:DIV/0! error in SumProduct formula with no division
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM

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