View Single Post
  #1   Report Post  
carlosgdlf
 
Posts: n/a
Default text argument in vlook up which has a ""


Hi to every body!

Im loking in a vertical look for a buff "N" the problem is that you
can not write a quotation marks(") in an argument simply like that,
con in the example below what the program is interpreting the quotation
after buff as the end of the string and is specting next a coma instead
of an N.

So the cuestion is I have to look in a column for a word that contents
quoutations what do i have to write to look for this argument BUFF "N"




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


Thanlks in advance!!


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