Display text from a single cell in a column range
 

I need to display the text from a single cell in a fixed column range, but
the location of the cell with text in it varies. The fixed column range I
have is P25:P40000. This column range will either be completely blank, or
will have a single cell within the range that will contain text (could be
cell P48 one time, cell P2705 the next, cell P30 the next, etc.). If there
is a cell with text in it somewhere in column range P25:P40000, I want to be
able to display that cell's text in cell Y5.

Any ideas?

Display text from a single cell in a column range
 

Put this formula in Y5:

=LOOKUP("zzzzzzzzzz",P25:P40000)

Hope this helps.

Pete


On Jul 18, 11:27*pm, brettopp
wrote:
I need to display the text from a single cell in a fixed column range, but
the location of the cell with text in it varies. *The fixed column range I
have is P25:P40000. *This column range will either be completely blank, or
will have a single cell within the range that will contain text (could be
cell P48 one time, cell P2705 the next, cell P30 the next, etc.). *If there
is a cell with text in it somewhere in column range P25:P40000, I want to be
able to display that cell's text in cell Y5.

Any ideas?

Display text from a single cell in a column range
 

This column range will either be completely blank,
or will have a single cell within the range that will
contain text

One way:

=INDEX(P25:P40000,MATCH("*",P25:P40000,0))

--
Biff
Microsoft Excel MVP


"brettopp" wrote in message
...
I need to display the text from a single cell in a fixed column range, but
the location of the cell with text in it varies. The fixed column range I
have is P25:P40000. This column range will either be completely blank, or
will have a single cell within the range that will contain text (could be
cell P48 one time, cell P2705 the next, cell P30 the next, etc.). If
there
is a cell with text in it somewhere in column range P25:P40000, I want to
be
able to display that cell's text in cell Y5.

Any ideas?