Copying a formula with a relative cell reference

T

Tany

I've constructed a formula that links information from two spreadsheets. My resulting formula looks like, "=IF('[Purchases & Acq FY03.xls]Jeff'!L$32=1341,+'[Purchases & Acq FY03.xls]Jeff'!D$32)". Well, I need to be able to copy the formula down without manually increasing the row reference from L$32 to L$33, L$34. Please advise me on an easier more efficient to accomplish this. Thanks
 
A

Andy B

Hi

If I understand you correctly, you can just change L$32 to L32. This will
now increment as you fill down.

--
Andy.


Tany said:
I've constructed a formula that links information from two spreadsheets.
Click to expand...
My resulting formula looks like, "=IF('[Purchases & Acq
FY03.xls]Jeff'!L$32=1341,+'[Purchases & Acq FY03.xls]Jeff'!D$32)". Well, I
need to be able to copy the formula down without manually increasing the row
reference from L$32 to L$33, L$34. Please advise me on an easier more
efficient to accomplish this. Thanks
 
J

Jason Morin

Remove the $ from the reference, then fill down.

HTH
Jason
Atlanta, GA
-----Original Message-----
I've constructed a formula that links information from
Click to expand...
two spreadsheets. My resulting formula looks like, "=IF
('[Purchases & Acq FY03.xls]Jeff'!L$32=1341,+'[Purchases &
Acq FY03.xls]Jeff'!D$32)". Well, I need to be able to
copy the formula down without manually increasing the row
reference from L$32 to L$33, L$34. Please advise me on an
easier more efficient to accomplish this. Thanks
 
Top