#REF! Error

[Reefaman]

Hello I am using this formula to extract data from one worksheet to
another:
=INDIRECT("Q"&ROW()+168&"!"&"$E$4")
The trouble is that when no info is in the cell being addressed I get
#REF! , anyboby any ideas on how to leave the cell blank when no info
is in the cell addressed.
Tony

 

[Ardus Petus]

IF(ISERROR(your formula),"",your formula)

HTH
--
AP

"Reefaman" <[email protected]> a écrit
dans le message de
news:[email protected]...

 

[prabhuraaman]

Use the ISERROR function
Then your formula would look like the following

=IF(ISERROR(INDIRECT("Q"&ROW()+168&"!"&"$E$4")),"
",INDIRECT("Q"&ROW()+168&"!"&"$E$4"))

For more,visit and post your questions on
http://groups.google.co.in/group/answers-for-everything

 

[Reefaman]

Thanks for the replies. Worked a treat. Cheers