KDD

Posts: n/a

Dropdown list/Multiple choice??

Hi.

I have 2 lists like this:

Code Name
X12 David
Z55 Arnold
AB223 Meechie etc

I would like to do cell validation and give user the option of using drop
down list in either of the columns, while the other column gets populated by
using VLOOKUP.

Is this possible, or an insane request?! Pls do help

KDDXB

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
dropdown menu	\PA via OfficeKB.com\	Excel Discussion (Misc queries)	7	July 9th 05 12:50 PM
How do I allow users to make a choice in a worksheet?	Jim Zavone	Excel Worksheet Functions	2	June 23rd 05 12:09 PM
Number of dropdown fields in Excel is limited. I need more. How?	UweVahrson	Excel Discussion (Misc queries)	7	March 28th 05 05:10 PM
Dropdown lists	metrueblood	Excel Discussion (Misc queries)	1	February 10th 05 12:17 AM
dropdown value from range in other sheet	mango	Excel Worksheet Functions	11	December 2nd 04 03:19 AM

All times are GMT +1. The time now is 06:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us