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,