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...
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.