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