Any ideas as to what may be causing the problem below? When I copy the
forumul to the cell above it, the COLUMN() references are mess up. I
was under the impression that COLUMN () was preferred over simply
putting in the column number.

Any help would really be appreciated.

Mike

=G8-((VLOOKUP($A8,'Harvest
Data'!$A$4:$T$2203,COLUMN(H1),0))*VLOOKUP($A8,'Harvest
Data'!$A$4:$T$2203,COLUMN($T1),0))

=G7-((VLOOKUP($A7,'Harvest
Data'!$A$4:$T$2203,COLUMN(#REF!),0))*VLOOKUP($A7,'Harvest
Data'!$A$4:$T$2203,COLUMN(#REF!),0))

Since you already are using H1 there are no more rows above H1 thus the
error, you use the COLUMN or better COLUMNS when you copy across not up or
down, if you need to copy the formula make the cell reference absolute

=COLUMN($H$1)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Takeadoe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Any ideas as to what may be causing the problem below? When I copy the
> forumul to the cell above it, the COLUMN() references are mess up. I
> was under the impression that COLUMN () was preferred over simply
> putting in the column number.
>
> Any help would really be appreciated.
>
> Mike
>
> =G8-((VLOOKUP($A8,'Harvest
> Data'!$A$4:$T$2203,COLUMN(H1),0))*VLOOKUP($A8,'Harvest
> Data'!$A$4:$T$2203,COLUMN($T1),0))
>
> =G7-((VLOOKUP($A7,'Harvest
> Data'!$A$4:$T$2203,COLUMN(#REF!),0))*VLOOKUP($A7,'Harvest
> Data'!$A$4:$T$2203,COLUMN(#REF!),0))
>

Thank you so much for the help!

Mike