#REF! Error
 

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


--
Reefaman
------------------------------------------------------------------------
Reefaman's Profile: http://www.excelforum.com/member.php...o&userid=31968
View this thread: http://www.excelforum.com/showthread...hreadid=520530

#REF! Error
 

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

HTH
--
AP

"Reefaman" a écrit
dans le message de
...

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


--
Reefaman
------------------------------------------------------------------------
Reefaman's Profile:
http://www.excelforum.com/member.php...o&userid=31968
View this thread: http://www.excelforum.com/showthread...hreadid=520530

#REF! Error
 

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 wrote:
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


--
Reefaman
------------------------------------------------------------------------
Reefaman's Profile: http://www.excelforum.com/member.php...o&userid=31968
View this thread: http://www.excelforum.com/showthread...hreadid=520530

#REF! Error
 

Thanks for the replies. Worked a treat. Cheers


--
Reefaman
------------------------------------------------------------------------
Reefaman's Profile: http://www.excelforum.com/member.php...o&userid=31968
View this thread: http://www.excelforum.com/showthread...hreadid=520530