This will return the rightmost (last) numeric value in the range B2:M2.

=LOOKUP(1E100,B2:M2)

This will return the corresponding column header from the range B1:M1.

=LOOKUP(1E100,B2:M2,B1:M1)

--
Biff
Microsoft Excel MVP


"Richard" wrote in message
...
Hi,

I have a list of part numbers that show cost prices by month for 2008. I
need to pull the last cost for 2008. Problem is, if there was no cost
change
for a particular month, then there is no entry in that cell for that
month.
The last cost for some parts may be in October or June, etc. Is there a
formula that can look down the row and pull the last cost no matter what
month it lands in?

Thanks,