Hi
this happens if rows/columns are deleted (and this happens if you
update your query)

--
Regards
Frank Kabel
Frankfurt, Germany

"Christen" schrieb im Newsbeitrag
...
I am getting an error in a report I am creating, while using the IF
statement. My statement looks like this: =IF(QUERY!F47="","
",QUERY!F47).
This report pulls data from a query sheet, and puts the data onto the
main
sheet. The error that I am receiving looks like this:
=IF(QUERY!#REF!="","
",QUERY!#REF!). I get this error for 5 rows on the report. For
example, if
my query has 30 records shown on the Query sheet, then rows 1-25 on
the main
sheet are displayed with correctdata, rows 26-30 shows the #REF error
in the
cell, and then rows 31 shows the last record from the query
correctly. Any
ideas on why this is happening? If i were to recopy the statement
down the
column after the data is pulled in, the error gets corrected. If i
go back
and change the criteria on the query and pull the data in again, the
error
comes back. I'm at a loss... Please help!!