Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists
I need to setup a small table with 2 columns and maybe 10 to 15 rows. I want
to be able to have a person access this info with either a list or drop down list so they can choose an item from the table and have it inserted into a cell. I would like the user to be able to see both columns because the left column will help them decide which item in the right colum they need to insert. The table could be on a seperate sheet. Also if something in the list is updated will everything chang where the info was previously inserted? Is this possible with Excel? Thank you for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists
Dig,
This is usually done with Data - Validation - List, against one column in the table, then using VLOOKUP formulas to get the other cells of that row in the table. Validation doesn't support showing two columns, but you can put an extra column in the table that has the two concatenated: = A2 & A3 = A2 & " " & A3 = A2 & "/" & A3 This concatenation will become the key that the VLOOKUPs must use, since that's what Validation list dropdown will put in the cell. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Dig" wrote in message ... I need to setup a small table with 2 columns and maybe 10 to 15 rows. I want to be able to have a person access this info with either a list or drop down list so they can choose an item from the table and have it inserted into a cell. I would like the user to be able to see both columns because the left column will help them decide which item in the right colum they need to insert. The table could be on a seperate sheet. Also if something in the list is updated will everything chang where the info was previously inserted? Is this possible with Excel? Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
lists from other lists in excel | Excel Worksheet Functions |