Jul 20 2022 07:52 AM
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 help would be great.
Jul 20 2022 08:00 AM
You could help us help you by giving some more specifics:
Is it possible, without violating confidentiality or privileged data, for you to post the workbook in question, or a mockup of it, either here in this forum or, that failing, on OneDrive or GoogleDrive?
Jul 20 2022 09:13 AM
@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.
Jul 20 2022 09:34 AM
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.
Jul 20 2022 05:00 PM
Jul 20 2022 05:09 PM
Jul 20 2022 07:06 PM
Jul 20 2022 07:09 PM