Indexing or Referencing the next cell above with value

Hi, I'm wondering if there's a function or method to reference the first cell up in a column that has a value with an unknown number of rows? I can manually do it with using INDIRECT or OFFSET but t...