Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lists
Okay, Sheet 1 ("Entry") Looks like this:
A B C D 1 Property Date Not Working Features I Like 2 Prop 1 8/14/05 Blender View 3 Prop 2 8/19/05 Bedrooms 4 Prop 1 5/19/05 Blender Landscaping 5 Prop 3 7/11/05 Deadbolt 6 Prop 2 9/15/05 MainTV View 7 Prop 1 10/12/05 Icemaker View Sheet 2 ("Owners") Must function like this: (A2 is a drop down list containing the names of properties from sheet 1. Step 1 in this process is to select a property from this list, hence "Prop 1" in A2) A B C D 1 Property Not Working Features I Like 2 Prop 1 Blender View 3 Blender Landscaping 4 Icemaker View 5 So the Question is: When I select "Prop 1" from My drop list in A2 on the "Owners" sheet, how do I get the list of information only pertinant to Prop 1 In columns B and C? Obviously I want to select Prop 2 and get Prop 2 Info if I so choose. Any Help would be appreciated! Jaytee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting lists question | Excel Discussion (Misc queries) | |||
How do I return dynamic lists? | Excel Worksheet Functions | |||
Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |