No need to sort if you use the FALSE argument.

=vlookup(a1,table,3,false)


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 12:53:02 -0700, Kassie wrote:

This list must be sorted alphabetically.
In the zip code column, you would then use a VLOOKUP formula to get the
correct zip codes.