Matching and Vlookups HELP

[Jminer13]

I have just used some vlookups to find some information on a Unique
ID. Unfortunely each week a few of these ID's are delelted and some
are added- so a vlookup can not find information pretaining to them.

The good news is that the data is sorted in such a way that when a
vlookup returns a NA, b/c it can't find info on the related to the ID,
that all data above it is what i need.

For instance, After running a Vlookup i left with:

ID's Region Location
1 NY NYC *Note: ID's 2,4, and 5 are
new and therefore the
2 NA NA Vlookup can't
find anything b/c there is no info on it.
3 CAL LA However, ID 2's,
region and location is the same as ID 1. Also,
4 NA NA ID 4 and 5
region and location info are the same as 3.
5 NA NA

In saying and showing, is there any way to make a formula that would
find any NA returned by the Vlookup and match the region and locations
associated with the ID to those above it.


Thank you.

 

[Earl Kiosterud]

J,

Just a note. When you post, wait a while to see your post -- it can take a while for posts
to appear, even if you've connected directly to news.microsoft.com. Longer if you're using
another USENET server.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...