Hi, first time posting for me. Great site which has helped be out alot. Anyhow using a Vlookup for stock codes and have come across a problem. In the many stock codes I am looking up the majority return what I would expect via my Vlookup however when looking up FF*291 verses FF*1291 the vlookup always returns the FF*1291 result and not the result for FF*291. So my result is the same for both stock codes which are different! I am using the exact match entry ie FALSE but am stuggling to understand this one. When I sort the codes and have FF*291 before FF*1291 it works. I want an exact match so not interested in having to sort my data. Any help is most welcome. Cheers