I am trying to take a sheet that is referenced from another sheet and display if it is empty put " " if not " " or empty then display the information inside the cell.
='J:\Systems\Data\User\A\[A (2).xlsm]Cover'!B15
I was trying to do this but I know this is not right
=IF(a1=" "', J:\Systems\Data\User\A\[A (2).xlsm]Cover'!B15), IF a1=J:\Systems\Data\User\A\[A (2).xlsm]Cover'!B15)
Please let me know if anyone can help.
Thanks,
-J
Bookmarks