You were VERY close:

=VLOOKUP(B4+" Total",'[Period 6 sales by
SKU.xls]MFGRP-34_MFR-43152_20050522-200'!$B$29:$I$5643,8,FALSE).

Should be:
=VLOOKUP(B4&" Total",'[Period 6 sales by
SKU.xls]MFGRP-34_MFR-43152_20050522-200'!$B$29:$I$5643,8,FALSE).

Reason:
The + sign is an arithmetic operator
The & sign is a text concatenator

Example:
="any"&"thing" evaluates to "anything"
while ="any"+"thing" evaluate to #value

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=383584