The following formula assumes your table is in the upper most left hand part
of your spreadsheet... e.g. part 1,2,3 ended up in A2,A3,A4 and your month
names are in B1, C1, D1, etc.

=VLOOKUP("part1",$A$2:$I$4,MAX(IF(A2:I2<"",COLUMN (A2:I2),"")),0)

--
Regards,
Dave


"Hirsch" wrote:

Imagine:
Jan Feb Mar Apri May June July Aug Sep Oct Nov Dec
part 1 2 2.5 2.5 3 3.25
part 2 1 1.1
part 3 6 7 34

I'm looking for a seperate column that will list out the last value entered
in a series of colums: hense (part 1) = 3.25 (part two) = 1.1 (part 3) = 34.

In my attempt to find a formula I thought of something like
=lastvalue(b3:b15) but that's not a formula.

Does anyone have any suggestions? As usual thanks in advance.