Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Help - Easy Q not sure if need IF or LOOKUP | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |