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

=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

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