Originally Posted by Dave H

I am trying to use a vlookup to lookup a value. Where the value I am looking up is say abcd but on my table it would be abc*. I can truncate abcd to abc and it will find it if I remove the *s from my table. However not every value on my table has an *. Is there a simple way to do this? I don't want to use true as I don't want an approximate match.