Fixing a formula

B

Boethius1

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

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

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

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

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

Please help
 
A

Andrew Houghton

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
 
B

Boethius1

Thanks that worked a treat.

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


Andrew said:
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" <[email protected]>
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?action=getinfo&userid=30497
View this thread: http://www.excelforum.com/showthread.php?threadid=502627
Click to expand...
Click to expand...
 
Top