Thanks. This worked for the last instance. Great. I have done a lot with
lookup's and vlookups. I have never used the array lookup.
I don't understand the lookup 2 and then what are you dividing by 1??

"T. Valko" wrote:

Try this for the *last* instance:

=LOOKUP(2,1/(V1:V100="High River"),W1:W100)

--
Biff
Microsoft Excel MVP


"DRC" wrote in message
...
I have city names and postal codes. There are several postal codes for each
city.
Cities are in colum V and Postal codes are in column W. Example:
there are 210 different postal codes for High River. these postal codes
are
usually in sequencial order. Using Vlookup I can get the first instance
of
the postal code but I can't figure out how to get the last instance. I
would
then be able to say that High River has a postal code range from X to XX.
Can anyone help.