Display text from a single cell in a column range

[brettopp]

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 P2540000. 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 P2540000, I want to be
able to display that cell's text in cell Y5.

Any ideas?

 

[Pete_UK]

Put this formula in Y5:

=LOOKUP("zzzzzzzzzz",P2540000)

Hope this helps.

Pete

 

[T. Valko]

This column range will either be completely blank,

or will have a single cell within the range that will
contain text

One way:

=INDEX(P2540000,MATCH("*",P2540000,0))