Nested IFERROR

I am using the below formula that is working fine:

=IFERROR(IFERROR(INDEX({Sales_Parts_1_Description}, MATCH($[Supplier Part Number]@row, {Sales_Parts_1_PN}, 0)), INDEX({Sales_Parts_2_Description}, MATCH($[Supplier Part Number]@row, {Sales_Parts_2_PN}, 0))), "ERROR - CHECK PART #")

However, I want to add another INDEX statement. When I do, I get an #incorrect argument set error. Is the below even possible?

Find more posts tagged with

Formulas

Comments

Mike Wilday

Couple things I would check if I were you... Make sure you are closing all of your IFERRORS correctly. Based on a quick glance it looks like you are not closing them right.

You were trying to close both of the IFERRORS at the end.

Try this slight modification and let me know if it works.

Paul Newcome

One thing I have found that helps when nesting more complicated and/or longer formulas is to break them out, ignore the data itself and start with nesting the basic syntax.

=IFERROR(first formula, second formula)

You already have the first formula worked out, so leave that portion as is. Figure out what you want the second portion to be and work that out as a stand alone.

Once you have that working, you can drop that into place where it says second formula.

Then you can go ahead and take that first formula (IFERROR included) and drop that into the first formula portion.

I have found that it really helps with making sure each portion is closed out the way it needs to be, and it helps with trouble shooting because you have each portion broken out already.

Sign in to join the conversation!

Quick Links

Trending discussions

Pulling in data from 1 sheet to another isn't working with any function.
PMO Template - I want to pull in the Project Name Column from the Project Metadata sheet into my custom Attendance Sheet > Project Name Column. I've tried VLOOKUP, INDEX MATCH, JOIN COLLECT, I've changed parenthesis to brackets. I am new to Smartsheets and can't get anything to work. I've watch videos, followed community…
Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
Logging separate data points of the same type of data for one row
Looking for a way to easily log and reference multiple data points for the same type of data (ex: successful phone contacts) that all show for one entry (by member name). Want this to be both easy to enter the information (ideally by interacting with the same row via Dynamic View), and easy to see data on the back end of…