Forum Discussion
disappearing text
I have a large Excel spreadsheet that I use every day to track social media advertising. It has 2 rows at the top and 3 columns at the left that I typically keep frozen so I can fill in information i...
Stay on any cell within the range and check what are conditional formatting rules applied to the range. If you share if not sample file or at least screenshots we may discuss details.
I have a same problem. Could you check it for me please. Is there any conditional range to hide cell. I do not understand why the cell still empty even I put the formula in the bar.
regards,
Unur
IFERROR returns empty string since INDIRECT returns an error. Sheet name shall be used with single apostrophes, like 'Sheet One'!A1. Exception is for one-word sheet names.
In your case
=IFERROR( INDEX(INDIRECT("'" & J4 & "'!$I12:$I1011" ),H4), "" )shall work.
