text argument in vlook up which has a ""

C

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

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
 
J

Jon Quixley

Carlos

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

=vlookup(" Buff 'N' ", etc

Cheer
 
C

carlosgdlf

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

Ron said:
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
Click to expand...
 
C

carlosgdlf

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

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.
 
R

Ron Coderre

When you use this:

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

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

Regards,
Ro
 
Top