vlookup lookup_value text

[natk]

I have a very simple vlookup function that I am using to pull data from
another worksheet. The problem I'm having is that the text I'm referencing as
the lookup_value contains a quotation mark ... 18" Bead Diameter. So, if I
key it in as "18" Bead Diameter" of course it gives me an error. The
correction Excel suggests is "18""BeadDiameter" which is not correct. Can't
figure out how many quotation marks I need and where to put them to make this
work.

Thanks in advance!!

 

[T. Valko]

18" Bead Diameter

Excel suggests is "18""BeadDiameter"

Excel's suggestion has removed the spaces. That will work, just add the
spaces:

=VLOOKUP("18"" Bead Diameter",F1:G10,2,0)

Better yet, use a cell to hold the lookup value:

A1 = 18" Bead Diameter

Then:

=VLOOKUP(A1,F1:G10,2,0)

 

[natk]

Ok... got it. I knew it was taking out spaces, but wasn't sure how to
account for the spaces that did belong.

How about this one? 43" - 45" ...

I know it would be better to just reference a cell containing this, but I
can't alter the structure of the worksheet b/c someone else's sheets are fed
from it and I don't want to cause them grief in having to change their
format/formulas. : p

Thanks!!

 

[T. Valko]

How about this one? 43" - 45" ...

=VLOOKUP("43"" - 45""",F1:G10,2,0)