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