Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Picking specific records from a table
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Size | Charts and Charting in Excel | |||
data table based on data table | Excel Discussion (Misc queries) | |||
Referencing a specific number to more general values in a table. | Excel Worksheet Functions | |||
How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) |