I am currently trying to pull data into a primary sheet from several ancillary sheets. I thought about taking the data from the ancillary sheets, 8 of them, and putting them into one sheet but there are simply too may opportunities to mess the data up. I also hoped I could create a report that pulled in the necessary data from the sheets and run a single index/match from that report. I quickly found out you cannot use a report in an index/match formula.
So, I'm now at a place where I think I'm going to have to use a nested IF statement with index/match as the true condition. I'd like to know if anyone else has done this OR if they have any suggestions that will prevent me from having 7 nested IF statements.
Help Article Resources
Check out the Formula Handbook template!