Sorry, we've had internet problems so it took me a while to get back to this.
I don't know what happened I tried adding the False earlier and it didn't
work; tried it today and it worked perfectly. Thanks so much!!!
--
Thanks all!!!


"Gord Dibben" wrote:

You need another agument to keep Excel from finding closest match.

=VLOOKUP(77002,Sheet3!A1:B10,2,FALSE)

will return NA if not found.

=IF(ISNA(VLOOKUP(77002,Sheet3!A1:B10,2,FALSE)),"", VLOOKUP(77002,Sheet3!A1:B10,2,FALSE))

will return a blank looking cell if not found.


Gord Dibben MS Excel MVP


On Wed, 9 Sep 2009 14:27:02 -0700, Gayle wrote:

Per, thank you!! This was a great start. It works fine when the zip code is
within the groups. However we have zips in Texas or even other states that
do not appear in our groups but do appear in the member record. On those it
needs to return NA or blank or something. Right now it's just picking one of
the group. Any more ideas?