Invalid nested formula syntax

[Irukandji81]

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

[sandy666]

try this, should work if I didn't mistake

Please Login or Register  to view this content.

[Logit]

.
Irukandji81 :

Your post title should read something like : Formula Error, Multiple INDEX/MATCH for Multiple Sheets. Please edit your title.

The following isn't causing any error messages but you will need to check it and verify it works for your needs:

Please Login or Register  to view this content.

[sandy666]

or simpler: Invalid nested formula syntax

[Irukandji81]

The formula is working now except one issue. The actual tab names I have contain dashes (e.g. tab-1). When I try to put those names in it is giving me a pop up trying to link to another worksheet. Is there something needed in order to specify a specific tab name? Quotes or a symbol of some sort perhaps?

[sandy666]

maybe: 'tab- 1'!A1.....

the best way is attach example excel file

edit:
all used names of sheets should exist in your workbook else formula lookin' for another workbook or non-existing target with used name

[Irukandji81]

that did it thank you!

[sandy666]

You are welcome

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)

If you did it - ignore it.
Thank you.