Max

I hadn't noticed that you had corrected my formula.
Many thanks

--
Regards
Roger Govier

"Max" wrote in message
...
Here's a quick sample illustrating how you can get it to propagate using
INDIRECT and ROWS when you copy down from the top cell:
http://www.freefilehosting.net/download/3c1a8
Indirect.xls

In Log,

In A4, copied down:
=IF(INDIRECT("'REQ ("&ROWS($1:1)&")'!D4")="","",INDIRECT("'REQ
("&ROWS($1:1)&")'!D4"))

In E4, copied down:
=IF(INDIRECT("'REQ ("&ROWS($1:1)&")'!D10")="","",INDIRECT("'REQ
("&ROWS($1:1)&")'!D10"))


In Log (2),
Roger's earlier suggestion using ROW(A1), slightly amended

In A4, copied down:
= IF(INDIRECT("'REQ ("&ROW(A1)&")'!D4")="","",INDIRECT("'REQ
("&ROW(A1)&")'!D4"))

In E4, copied down:
= IF(INDIRECT("'REQ ("&ROW(A1)&")'!D10")="","",INDIRECT("'REQ
("&ROW(A1)&")'!D10"))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---