Right now I have spreadsheet that is referencing other spreadsheets outside of the workbook. The file is not there now but when it shows up the data will update. I am using the INDIRECT.EXT function. Since nothing is there now I am receiving the #REF! error. How might I have that error disappear until the file is in its place. I assume an IF function but I don't know what notation to use to make it go away. Any help will be appreciated!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help On #REF! Error
- Thread starter pwebley
- Start date
energman58
Well-known Member
- Joined
- Oct 25, 2010
- Messages
- 553
IF(ISERROR(Your formula),"",Your formula) will work for all errors including #N/A
Upvote
0
