I am using vlookup to lookup an item# for a lot#. sometimes the item# is just numbers and sometimes numbers and 1-2 letters, the letters can be at the begining or end of the item#. Once I lookup a number with letters I get #value!.
How do I get around this??
How do I get around this??