Another one:

=INDEX(B:B,MATCH("*",B:B,0))

Biff

"Adam Graham" <Adam wrote in message
...
All of column B is empty except one cell. The non-empty cell is in a
different place each week. I want a formula that will give the text in
the
nonempty cell, regardless of which cell is nonempty at that point in time.
For example.

Week 4
Cell should say "Text 4"

A B
1
2
3
4 Text 4


Week 2
Cell should say "Text 2"

A B
1
2 Text 2
3
4


Thanks