Related Post: Vlookup Match First 5 Characters Vlookup Match First N Characters Vlookup Match Last 5 Characters Vlookup Match First Characters Vlookup Match First 10 Characters