Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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...
 
Back
Top