Ok here goes. I have a data sheet that has zip codes in one column. It has a listing of 5+4 so I need a forumla that will take the +4 away and put in only the first 5 of the zip. Now I have a table of data of all zip codes in my region of the northeast states this is a long list in column A then in column B it has the office that is listed for that zip code (example would be city). What I need to be able to do is to have excel lookup from my "lookup list" the zip code then enter that city in another data field on the sheet. Main sheet

A B

22209 Waiting for data from lookupLookup sheet

A B

zipcode OrlandoI need the main sheet to hold the forumla in column A and Column B. Then when I have a zip code to input in column A it goes out to "lookup sheet" finds zip code and puts the city in Column B.

I'm using =vlookup(B483,lookup,2,False) that does work except I have to click the function box each time to get the lookup to work. I'd like to be able to enter the zipcode and have it do the lookup and put the data in the column without having to use the function each time. Automatically if possible. Can this be done? Thanks.

re: I need a forumla that will take the +4 away and put in only the first 5 of the zip.=LEFT(A1,5)

re:

I have to click the function box each time to get the lookup to workand

re:

put the data in the column without having to use the function each timeI'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?

Thank you for your reply back. The function used to work but my computer died and was replaced and reloaded with all the new software. I did look up as you said to make sure it was set to Calculation to Automatic. It was set to Manual don't know how that happened but it works now. Had a much more complicated formula for my lookup table but even simplified that to a much shorter and better look. I think it's about time to get some classes in Excel. Again thanks and you have solved my problem.

Ask Your Question

Weekly Poll

Do you think its a good idea for Amazon to divide its new second headquarters between two locations?

Discuss in The Lounge

Poll History