but it doesnt work i dont know why it does accept the argument but
doesnt get the expected number

Ron Coderre Wrote:
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


--
carlosgdlf
------------------------------------------------------------------------
carlosgdlf's Profile: http://www.excelforum.com/member.php...o&userid=25821
View this thread: http://www.excelforum.com/showthread...hreadid=392162