Trouble with hyhens within text when using LOOKUP

  • Thread starter Dennis via
  • Start date

Dennis via

I have two columns, each containing a list of part numbers. Some of the part
numbers contain hyphens.
I am using LOOKUP and/or VLOOKUP to determine if the value in one column
exists in the other. This works great on non-hyphenated part numbers.
However, it will not find or return the hyphenated part numbers from the
specified arrays. As a test, I did a quick if statement to compare the
instances of identical hyphenated values that exist in both columns. Those
statements did not have a problem with the hyphens. Can anyone offer any
help? If hyphens cannot be used in conjunction with the LOOKUP functions, can
I strip the hyphens out of the numbers?




When You Created your Vlookup Formula did you use false in th
Range_lookup field? ie: "=VLOOKUP(B3,A7:B12,2,FALSE)"


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