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

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)

--
Biff
Microsoft Excel MVP


"natk" wrote in message
...
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!!

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" wrote:

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)

--
Biff
Microsoft Excel MVP


"natk" wrote in message
...
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!!

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

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


--
Biff
Microsoft Excel MVP


"natk" wrote in message
...
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" wrote:

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)

--
Biff
Microsoft Excel MVP


"natk" wrote in message
...
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!!