Forum Discussion
Nested IFERROR Help
I’m trying to lookup prices from a sheet using index and match. I ran into problems with my initial index and match, so started by doing 3 different index and matches for the different product ty...
Hello BooBar87
I would not advise you to do so. The formulas are already complex and it may become harder and harder to figure out how things are working in the future when you have moved on to other things.
What I would favor is using "Helper Columns" where you would do intermediate lookups and calculations and then where you want the data to be you will use a formula that reference these "Helper Columns". The advantage of this approach is simpler formulas and functions that can be easily debugged. The disadvantage is that you want want to hide these columns and that might make your report a bit unprofessional.
Look at this for more details:
https://www.exceltip.com/basic-excel/what-is-an-excel-helper-column.html
https://exceljet.net/glossary/helper-column
https://www.reddit.com/r/excel/comments/14k1vr6/is_it_ever_appropriate_to_have_to_use_helper/?rdt=50571
I hope I gave you food for though.
G.
I would not advise you to do so. The formulas are already complex and it may become harder and harder to figure out how things are working in the future when you have moved on to other things.
What I would favor is using "Helper Columns" where you would do intermediate lookups and calculations and then where you want the data to be you will use a formula that reference these "Helper Columns". The advantage of this approach is simpler formulas and functions that can be easily debugged. The disadvantage is that you want want to hide these columns and that might make your report a bit unprofessional.
Look at this for more details:
https://www.exceltip.com/basic-excel/what-is-an-excel-helper-column.html
https://exceljet.net/glossary/helper-column
https://www.reddit.com/r/excel/comments/14k1vr6/is_it_ever_appropriate_to_have_to_use_helper/?rdt=50571
I hope I gave you food for though.
G.
GeorgieAnne OliverScheurich thanks for your replies, I got some advice on a different approach and the issue is now resolved!
