Hi Phil

On sheet2 in cell C2
=VLOOKUP(A2,Sheet1!$A$2:$A$1000,2,0)
and copy down.

Once done, copy the whole of column C and Paste SpecialValues to C1 and
this will replace the formula with the Parcel_ID's

Change range to suit.

Regards

Roger Govier



Phil wrote:

I have 2 worksheets that I'd like to see if I can do a match with each one,
using the column Tract_ID, which common to both. So table "A" has 2 columns:
Tract_ID and Parcel_ID, table "B" has 2 columns: Tract_ID and Owner. I'd
like to have it so I could have one new table "C" with BOTH the Tract_ID,
Parcel_ID, and Owner.

Can this be done?

If so, how?

Please let me know if you need more info.

TIA.