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.