Years ago, my business decided to prefix products to quickly identify a products "Status". Unfortunately they decided to use a *, which of course in excel denotes a wildcard character.
I am trying to vlookup a table to quickly translate the prefixes but those with a * do not lookup correctly...