Hello,
In the below formula, column P is a date column with some blanks. In the below formula I am returning the last populated year looking up from row 50. What I need to know is how to turn P50 into a dynamic cell reference based on whichever row the formula is in:
=IF($P50="",LOOKUP(2,1/($P$2:P50<>""),$P$2:P50),(YEAR($P50)))
In the below formula, column P is a date column with some blanks. In the below formula I am returning the last populated year looking up from row 50. What I need to know is how to turn P50 into a dynamic cell reference based on whichever row the formula is in:
=IF($P50="",LOOKUP(2,1/($P$2:P50<>""),$P$2:P50),(YEAR($P50)))