Fixing a formula
 

I have the following equation, it is looking up in another worksheet and
pulling through information when it finds a match in second file from
cell d in first file.

=VLOOKUP(D10,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!C4:O81,4,FALSE)

This is working but when i copy the equation down a few rows the
equation changes to this and it should still be looking at Sheet 1 C4
to O81.

=VLOOKUP(D14,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!C8:O85,4,FALSE)

I know i need to fix part of the equation but don't know how or which
bit.

Please help!


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=502627

Fixing a formula
 

change it to this:

=VLOOKUP(D10,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!$C$4:$O$81,4,FALSE)


The dollar sign indicates the absolute reference for each part of a
reference it prefixes. In the instance I have supplied the row and column
are now fixed.

Andy
"Boethius1" wrote
in message ...

I have the following equation, it is looking up in another worksheet and
pulling through information when it finds a match in second file from
cell d in first file.

=VLOOKUP(D10,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!C4:O81,4,FALSE)

This is working but when i copy the equation down a few rows the
equation changes to this and it should still be looking at Sheet 1 C4
to O81.

=VLOOKUP(D14,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!C8:O85,4,FALSE)

I know i need to fix part of the equation but don't know how or which
bit.

Please help!


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile:
http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=502627

Fixing a formula
 

Thanks that worked a treat.

---------------------:)


Andrew Houghton Wrote:
change it to this:

=VLOOKUP(D10,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!$C$4:$O$81,4,FALSE)


The dollar sign indicates the absolute reference for each part of a
reference it prefixes. In the instance I have supplied the row and
column
are now fixed.

Andy
"Boethius1"
wrote
in message
...

I have the following equation, it is looking up in another worksheet
and
pulling through information when it finds a match in second file
from
cell d in first file.

=VLOOKUP(D10,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!C4:O81,4,FALSE)

This is working but when i copy the equation down a few rows the
equation changes to this and it should still be looking at Sheet 1
C4
to O81.

=VLOOKUP(D14,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!C8:O85,4,FALSE)

I know i need to fix part of the equation but don't know how or
which
bit.

Please help!


--
Boethius1



------------------------------------------------------------------------
Boethius1's Profile:
http://www.excelforum.com/member.php...o&userid=30497
View this thread:
http://www.excelforum.com/showthread...hreadid=502627



--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=502627