I think the formula does have an error in it.
If you use the IF(ISERROR) function, to check for an #REF error, the function needs to be of the type;
In that example, B6 refers to cell A1 in another sheet which I made to be non-existant, hence B6 shows #REF.
So, I then put this forumla into D6. What it does is this.
If B6 shows an error, then ISERROR is True. If B6 does not show an error, then ISERROR is False.
If True, then "error" is displayed in D6, (without the quotes).
If False, then the value of B6 is displayed.
You can use this. The data is imported into a range of cells, then copied using the ISERROR function into another range.
Then use the "2nd" range to do your checking and calculating, and referencing for the other sheets.
I hope this helps
Hi, I need some help. I have a workbook with 3 sheets, 1. a report that draws data from 2. a page to manually key in data and 3. a sheet where data is imported.
I need to make a cell that, when the imported data is refreshed, simply displays a field from page 3. However, on occasion, this field may be empty. When this is the case, I get a #REF! error for this field. Insted of getting the #REF! error, I'm trying to get it to pull from a corresponding cell on page 2 that the user can key in (in the case that it is missing from page 3).
After looking through the help files, here's what I found that seems like it will work, but I keep getting formula errors:
=IF(ISERROR('Auto Entry'!C332<>0),'Auto Entry'!C332,'Manual Entry'!B8)
As I read it, if AutoEntryC332 is not empty, then this formula should display the contents of AutoEntryC332. If it is empty, then it should display ManualEntryB8 instead of the error.
What am I doing wrong?