Picking specific records from a table
Try this:
Assume this is in Sheet2, starting in cell A2:
101-001-000-000
101-003-001-001
The other data is on Sheet1, starting in cell A2.
Enter this formula on Sheet2 cell B2:
=INDEX(Sheet1!C$2:C$6,MATCH($A2,Sheet1!$A$2:$A$6,0 ))
Copy across to cell C2 then down as needed.
Biff
"Rick Ball" wrote in message
...
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.
|