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