|re: I need a forumla that will take the +4 away and put in only the first 5 of the zip.|
re: I have to click the function box each time to get the lookup to work
re: put the data in the column without having to use the function each time
I'm confused. What do you mean by "without having to use the function"?
With your VLOOKUP formula you should just be able to enter a zip in B483, hit Enter, or tab or click outside the cell or whatever and the VLOOKUP should work.
Do you have calculation set to Automatic?