text argument in vlook up which has a ""

  • Thread starter Thread starter carlosgdlf
  • Start date Start date
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!!
 
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
 
Carlos

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

=vlookup(" Buff 'N' ", etc

Cheer
 
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...
 
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

read in Vlookup an argument that has quotations(") 1
Vlook up value is #N/A 4
Problem: How to copy excel sheet in C++ 0
Vlook-up in report with column Expansion 5
Comma in Function Argument name treated as separator 1
Problem in correct performance of calling a dialog in a DLL(Window 1
vlook up (average) 2
match and vlook up 4

Back
Top