In other words, you want to find the *first* number from left to right:

=INDEX(D1:H1,MATCH(TRUE,INDEX(ISNUMBER(D1:H1),0),0 ))

--
Biff
Microsoft Excel MVP


"BK" wrote in message
...
Last number searching from right to left in H - D:

Column Contents of Cell

C Formula in question
D - G No values at this time (future dates)
H Last value entered


"T. Valko" wrote:

Let's see what your idea of the *last* number is:

A1.....B1.....C1.....D1
..........10......22..........

Which do you consider to be the *last* number?

The formula I suggested will return 22 as the last number.


--
Biff
Microsoft Excel MVP


"BK" wrote in message
...
Is it possible for it to look from right to left for the last numeric
value?

"T. Valko" wrote:

Try this:

=LOOKUP(1E100,1:1)

That will return the *last numeric value* from left to right in row 1,
A1:IV1.

--
Biff
Microsoft Excel MVP


"BK" wrote in message
...
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