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?