I have an excel table that has 6100 zip codes. I want to use a vlookup function to search for a specific zip code and then deliver a numeric factor result. Zip codes are closer to text than number, but the resulting factor is a number. I can't get the vlookup to work using the proper formatting. Help.
Solved by X. Q. in 22 mins