excel formula for lookup after u enter data

Microsoft Excel 2003 (full)
August 23, 2010 at 06:59:41
Specs: Windows XP
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 lookup

Lookup sheet

A B
zipcode Orlando

I 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.


See More: excel formula for lookup after u enter data

Report •

#1
August 23, 2010 at 10:04:57
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 work

and

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?


Report •

#2
August 23, 2010 at 16:41:04
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.


Report •
Related Solutions


Ask Question