text argument in vlook up which has a ""

[carlosgdlf]

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!!

[Ron Coderre]

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

[Jon Quixley]

Carlos

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

=vlookup(" Buff 'N' ", etc

Cheers

[carlosgdlf]

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

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]

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

Carlos

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

=vlookup(" Buff 'N' ", etc

Cheers

[Jon Quixley]

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.

[Ron Coderre]

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