View Single Post
  #1   Report Post  
Phil
 
Posts: n/a
Default Can you match records from two different worksheets

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.