Hi,

Was trying to achieve the following - which seems easy in concept...

You look up a row entry on another worksheet and return it to the
current worksheet.

however, if the row entry is blank, return the next row entry down
instead, unless this row is blank in which case return the next one and
so on and so on etc.

Any help to do this appreciated

thanks
bob


--
bobpants
------------------------------------------------------------------------
bobpants's Profile: http://www.excelforum.com/member.php...o&userid=24909
View this thread: http://www.excelforum.com/showthread...hreadid=384472

If, when you say row, you mean one particular cell in the row
if your first row of interest is row 3 for example and Column A
to identify the first row with data, set up a cell, say A3, with
=min(if(A3:A100="",100,row(A3:A100))
Enter as array (Control-shift-enter)
in your row of interest enter
=indirect("sheet2!R"&$A$3&"C"&column()) and copy across as far as you need.
"bobpants" wrote:


Hi,

Was trying to achieve the following - which seems easy in concept...

You look up a row entry on another worksheet and return it to the
current worksheet.

however, if the row entry is blank, return the next row entry down
instead, unless this row is blank in which case return the next one and
so on and so on etc.

Any help to do this appreciated

thanks
bob


--
bobpants
------------------------------------------------------------------------
bobpants's Profile: http://www.excelforum.com/member.php...o&userid=24909
View this thread: http://www.excelforum.com/showthread...hreadid=384472

Duh, Too early in the morning
equation should be
=indirect("sheet2!R"&$A$3&"C"&column(),False)

"bobpants" wrote:

"bj" wrote:

If, when you say row, you mean one particular cell in the row
if your first row of interest is row 3 for example and Column A
to identify the first row with data, set up a cell, say A3, with
=min(if(A3:A100="",100,row(A3:A100))
Enter as array (Control-shift-enter)
in your row of interest enter
=indirect("sheet2!R"&$A$3&"C"&column()) and copy across as far as you need.
"bobpants" wrote:


Hi,

Was trying to achieve the following - which seems easy in concept...

You look up a row entry on another worksheet and return it to the
current worksheet.

however, if the row entry is blank, return the next row entry down
instead, unless this row is blank in which case return the next one and
so on and so on etc.

Any help to do this appreciated

thanks
bob


--
bobpants
------------------------------------------------------------------------
bobpants's Profile: http://www.excelforum.com/member.php...o&userid=24909
View this thread: http://www.excelforum.com/showthread...hreadid=384472