Try this:

=VLOOKUP(" buff "&Char(34)&"N"&Char(34)&" ",'[Production
Report.xls]1'!$A$1:$J$85,8,FALSE)


Note: Char(34) is a quotation mark.

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=392162