software

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: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=502627change 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
quot;Boethius1quot; gt; wrote
in message ...
gt;
gt; I have the following equation, it is looking up in another worksheet and
gt; pulling through information when it finds a match in second file from
gt; cell d in first file.
gt;
gt; =VLOOKUP(D10,'C:\New Code Set
gt; up\[gcodenewsetupcopy.xls]Sheet1'!C4:O81,4,FALSE)
gt;
gt; This is working but when i copy the equation down a few rows the
gt; equation changes to this and it should still be looking at Sheet 1 C4
gt; to O81.
gt;
gt; =VLOOKUP(D14,'C:\New Code Set
gt; up\[gcodenewsetupcopy.xls]Sheet1'!C8:O85,4,FALSE)
gt;
gt; I know i need to fix part of the equation but don't know how or which
gt; bit.
gt;
gt; Please help!
gt;
gt;
gt; --
gt; Boethius1
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Boethius1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30497
gt; View this thread: www.excelforum.com/showthread...hreadid=502627
gt;

Thanks that worked a treat.

---------------------Andrew Houghton Wrote:
gt; change it to this:
gt;
gt; =VLOOKUP(D10,'C:\New Code Set
gt; up\[gcodenewsetupcopy.xls]Sheet1'!$C$4:$O$81,4,FALSE)
gt;
gt;
gt; The dollar sign indicates the absolute reference for each part of a
gt; reference it prefixes. In the instance I have supplied the row and
gt; column
gt; are now fixed.
gt;
gt; Andy
gt; quot;Boethius1quot; gt;
gt; wrote
gt; in message
gt; ...
gt; gt;
gt; gt; I have the following equation, it is looking up in another worksheet
gt; and
gt; gt; pulling through information when it finds a match in second file
gt; from
gt; gt; cell d in first file.
gt; gt;
gt; gt; =VLOOKUP(D10,'C:\New Code Set
gt; gt; up\[gcodenewsetupcopy.xls]Sheet1'!C4:O81,4,FALSE)
gt; gt;
gt; gt; This is working but when i copy the equation down a few rows the
gt; gt; equation changes to this and it should still be looking at Sheet 1
gt; C4
gt; gt; to O81.
gt; gt;
gt; gt; =VLOOKUP(D14,'C:\New Code Set
gt; gt; up\[gcodenewsetupcopy.xls]Sheet1'!C8:O85,4,FALSE)
gt; gt;
gt; gt; I know i need to fix part of the equation but don't know how or
gt; which
gt; gt; bit.
gt; gt;
gt; gt; Please help!
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Boethius1
gt; gt;
gt; gt;
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Boethius1's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30497
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=502627
gt; gt;--
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=502627