I should clarify: I need to reference the nearest cell with text in the same
column above the current cell.

"Kris W" wrote:

Is there a way to reference the nearest cell above the current cell that has
text - distance is always going to be variable.