Column with the current values.

[Engineer@pnb.retired_1987 Don Schmidt]

I have a lotus sheet with columns representing end of the month values and
would like to copy the latest column in a summary area of the sheet. Getting
the latest column seems easiest by using the formula @max(a1.a12) on the
date row.

Example using Feb as the latest month.

A B C D E F G H I J K L P

Jan Feb Months are added each month. Feb Formula
@max(a1..l2)

Apples $1 $2 $2

Bananas $3 $2 $2

Cherries $7 $6 $6

Dates $4 $5 $5

How to get the $2 down to the $5 to copy automaticly in column P?

I've considered using the Vlookup but can't make it work.

Any help is appreciated.

Don

Vancouver, WA