Just create a lookup table with the name in col 1 and the number in col 2
and then use a vlookup referring to your data validation
=vlookup(datavalidationcell,lookuptable,2,0)
=vlookup(a1,a2:b22,2,0)
best to post these EXCEL questions here
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
Don Guillett
SalesAid Software
[EMAIL PROTECTED]
----- Original Message -----
From: "Pranav Lal" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, April 19, 2006 9:47 AM
Subject: Microsoft Excel: adding corresponding numbers to drop downs
Hi all,
I have a project tracking application in Excel. One of the columns is the
name of the employee. Lets say that the employee's name is in cell a2. I
want the next column to have the employee code number. So, if The user
selects John Smith then the number 302 should come in cell b2 while if the
user chooses Joe Bloke who is in cell a4 the number 402 should come in
cell
b4.
I am using the data validation feature to construct the drop down. The
employee names and codes are on another sheet in the workbook.
Pranav
--
----------------------------------------
The WIN-HOME mailing list is powered by L-Soft's renowned
LISTSERV(R) list management software. For more information, go to:
http://www.lsoft.com/LISTSERV-powered.html
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.3/317 - Release Date: 4/18/2006
--
----------------------------------------
The WIN-HOME mailing list is powered by L-Soft's renowned
LISTSERV(R) list management software. For more information, go to:
http://www.lsoft.com/LISTSERV-powered.html
