Hey folks...

I know this has had to have been done before. Basically, I have an
original worksheet, and another worksheet that contains values that I
want to populate a column in the original worksheet with, based on a
common field. But it gets tricky, because the 2nd worksheet contains
some IDs (common field values) that are NOT in worksheet 1. And I'd
like to know which ones those are, preferably with them being put into
a 3rd worksheet automatically...

here is the original spreadsheet in a nutshell:

PARCEL_ID | ELEVATION
1111
2222
3333
4444

The elevation field is empty--- it's the column I want to populate
using the output from a model I ran with the same parcel data, except
the model's parcel data includes some additional parcels which are not
part of the original spreadsheet. Here's an example--

PARCEL_ID | ELEVATION
1111.......................20
2222.......................21
7777.......................22
8888.......................23

(ignore the periods...they're place holders)

So, as you can see, I have a common field. I want to simply populate
spreadsheet 1 with the elevations from spreadsheet 2...but spreadsheet
2 contains some parcels that aren't in spreadsheet 1, and I'd like them
to be placed in a new speadsheet by themselves.

Any ideas?

Thanks in advance!