Hi Don, That did the trick.
Many thanks. Pranav -----Original Message----- From: Windows Home/SOHO [mailto:[EMAIL PROTECTED] On Behalf Of Don Guillett Sent: Wednesday, April 19, 2006 8:14 PM To: [email protected] Subject: Re: Microsoft Excel: adding corresponding numbers to drop downs 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 -- ---------------------------------------- To unsubscribe, mailto: [EMAIL PROTECTED] Is your picture included in the Official Win-Home List Members Profiles Page? http://www.besteffort.com/winhome/Profiles.html If not, write to: [EMAIL PROTECTED]
