Yes.

See VLOOKUP in Excel Help
--
Gary''s Student - gsnu200842


"BStacy" wrote:

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?