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

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

Carlos

Have you tried using single quotes around the N (are they really
neccessary anyway?)

=vlookup(" Buff 'N' ", etc

Cheers


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

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

I cannot since Im reading from a data bade ans I can nor modiffy the
names of the products, but thanks for the help
Carlos

Jon Quixley Wrote:
Carlos

Have you tried using single quotes around the N (are they really
neccessary anyway?)

=vlookup(" Buff 'N' ", etc

Cheers


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

Carlos,

OK, plan B

Try setting up a spreadsheet that has the B column containing the Buff
"N" title and the value of this in the next column (C) - this is your
database output. In the first column to the left of these, set an
alternative to Buff "N" as I suggested in the previous note:

Col A ColB Col C ColD ColE
Buff 'N' Buff "N" 15 Buff 'N' +
vlookup(d1,a1:c1,2)

This will return the value of column B, in this case Buff "N" complete
with double quote marks.


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

When you use this:

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

what incorrect value is returned? Without some details it's difficult
to isolate the problem.

Regards,
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