It didn't work. Sorry,
Thank you for trying.

Here is the original string I had made. It works in most of the
fields, except a few. I can't figure out why it is not working in
some.

=AK28='C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce
Allocation.xls]Cost Info'!$B$4 (VLOOKUP('C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Raw
Data'!BA28,'C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce
Allocation.xls]Cost Info'!$F$4:$J$9,5,FALSE)) AK28='C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$D$4
(VLOOKUP('C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce
Allocation.xls]Raw Data'!BA28,'C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost
Info'!$F$4:$J$9,5,FALSE)) AK28='C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$B$11
(VLOOKUP('C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce
Allocation.xls]Raw Data'!BA28,'C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost
Info'!$F$11:$J$16,5,FALSE)) AK28='C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$B$18
'C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Raw
Data'!BA28


--
tiggatattoo
------------------------------------------------------------------------
tiggatattoo's Profile: http://www.excelforum.com/member.php...o&userid=35104
View this thread: http://www.excelforum.com/showthread...hreadid=549978