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