I have two worksheets. The first table contains a record for each parcel of
land in town (4500 +/-) containing a lot number ID (101-001-000-000), owners
name and assessment value. The second table contains only records of parcels
that are in a particular zoning district that is proposed (1900 +/-). I need
to pick the owners names and assessment values from the  first table
matching the parcels in the second.

It seems I should use "VLOOKUP" -

Worksheet 1 has fields:

PARCEL_ID                LOCATION        OWNER                TOTAL VALUE
(among others)

101-001-000-000        123 Your Street    Joe Homeowner        450,000
101-002-000-000        456 Your Street    Harry Homeowner       25,000
101-003-000-000        123 My Street       Joe Doe
123,456
101-003-001-000        456 My    Street    Jane Doe
987,654
101-003-001-001        123 Any Street      Andy Owner                53,222
and so on for 4500 records

Worksheet 2 has one field:

PARCEL_ID

101-001-000-000
101-003-001-001

only 1900 selected records of the total 4500.