Fixing a formula

[Boethius1]

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!

[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
"Boethius1" <Boethius1.21uicm_1137613201.5943@excelforum-nospam.com> wrote
in message news:Boethius1.21uicm_1137613201.5943@excelforum-nospam.com...
>
> 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]

Thanks that worked a treat.

---------------------

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" <Boethius1.21uicm_1137613201.5943@excelforum-nospam.com> wrote
in message news:Boethius1.21uicm_1137613201.5943@excelforum-nospam.com...
>
> 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
>