Richard,

Maybe this. It finds the latest date in column A and returns Column B

=INDEX(B:B,MATCH(MAX(A:A),A:A,0))

Mike

"Richard" wrote:

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,