IFERROR INDEX/MATCH for multiple sheets

[mehare]

I'm using Excel 2010.
I'm using the below formula to populate the location of my inventory but I need to gather the data from column C of a third sheet, 'PLANTS' by matching it to column E. Also, if the inventory doesn't show up on any of the three sheets, I'd like it to populate "In stock".

=IFERROR(INDEX('CUSTOMER INFO'!B:B,MATCH(A3,'CUSTOMER INFO'!E:E,0)),INDEX(SUBSTATIONS!C:C,MATCH(A3,SUBSTATIONS!E:E,0)))

Can anyone help? Is there a simpler way of doing this?

[judgeh59]

without data I can't test this but the basic idea is to nest IFERROR's...this didn't give me any syntax errors and I think the logic works...

Please Login or Register  to view this content.

[mehare]

Thank you very much. Works perfectly!
I had tried nesting the IFERROR's but something wasn't working for me and I couldn't find the problem.

[judgeh59]

lucky shot in the dark....sort of........glad I could help

[judgeh59]

If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...