Any IIdeas?

T

Takeadoe

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))
 
P

Peo Sjoblom

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
 
Top