maintaining a link

[Brad K.]

How do I link a cell to a cell in another workbook so that it always links to
that same workbook even if the folder that they are in changes (they will
always be in the same folder as each other)?
Thanks,
Brad

[Craigm]

=IF($AA14<> " ",VLOOKUP(ABS($AA14),'C:\Reference\[TranMaster.xls]Translator'!$A$11:$AC$51,2,TRUE)," ")

The If statement checks to see if the cell is not empty

The Vlookup then looks into the "TranMaster.xls" workbooks ant Translator worksheet for a matching entry in the A11:AC51 range. It then returns the column two rows over from the matching entry.

I use this to turn site codes in to addresses.

Hope it helps

Craigm

[Brad K.]

Thanks Craigm.
What I am looking for was actually simpler than this, and it was doing what
I wanted all along. What you wrote is going to help on another sheet I am
working on though.
Brad


"Craigm" wrote:

>
> =IF($AA14<> "
> ",VLOOKUP(ABS($AA14),'C:\Reference\[TranMaster.xls]Translator'!$A$11:$AC$51,2,TRUE),"
> ")
>
> The If statement checks to see if the cell is not empty
>
> The Vlookup then looks into the "TranMaster.xls" workbooks ant
> Translator worksheet for a matching entry in the A11:AC51 range. It
> then returns the column two rows over from the matching entry.
>
> I use this to turn site codes in to addresses.
>
> Hope it helps
>
> Craigm
>
>
> --
> Craigm
> ------------------------------------------------------------------------
> Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
> View this thread: http://www.excelforum.com/showthread...hreadid=381722
>
>