Forum Discussion
Creating a Master Tab for multiple tabs
I am looking to get a formula that will auto insert "X" if the same cell from any other tabs has "Y" on it. Not sure what formula to use. The ones that I have tried all come back with errors. Any he...
mathetesI have used the if, iferror, vlookup formulas and keep getting a value error.
There is no confidentiality or privileged data, but not sure how to post it here.
INDIRECT would be a better function for referring to the same cell in a set of tabs. Here's a reference.
https://exceljet.net/excel-functions/excel-indirect-function
Notice, I suggested as an alternative to posting here that you post a copy on OneDrive or in GoogleDrive...just post a link here.