Zip Code/Service Area help

[BStacy]

In one spreadsheet, I have a list of zip codes in Column A. In a second
worksheet I have a list of zip codes in Column A and a Service Area name in
Column B.

In my first spreadsheet I want to fill in the service area name from the
second spreadsheet that corresponds to the zip code.

is there some function that will allow me to do that in excel?

 

[JLatham]

The VLOOKUP() function is what you want to use in column B on the first
worksheet.
Lets say that on the SECOND sheet your list of zip codes (and service areas)
goes from row 2 down to row 141. I will assume that the first zip code on
the first sheet is also in row 2. In B2 on the first sheet enter this
formula:

=VLOOKUP(A2,'Sheet2'!$A$2:$B$141,2,0)

You'll need to change 'Sheet2' to use the actual name of that second sheet.
From this point, you can fill that formula on down the column on the first
sheet and it will do the job for you.

CAVEAT: If a zip code is listed more than one time on the second sheet, the
formula will always return the service area associated with the first
occurance of that zip code on the second sheet.

Hope this helps some.

 

[Gary''s Student]

Yes.

See VLOOKUP in Excel Help