Hi,

This will return the contents of the last populated cell in row 2

=LOOKUP(2,1/(2:2<""),2:2)

or to shorten the range

=LOOKUP(2,1/(A2:M2<""),A2:M2)

Mike

"BK" wrote:

The math is simply the difference between the values in two cells, but one of
the cells will change each time the table is updated.

For example, Row 1 headers are Apr, Mar, Feb, Jan, etc. and the last column
is Prior Year. In At any given time, I want the value for the most recent
month minus the prior year. How do I get it to automatically pick up the
last non-blank cell in the row?

Thanks