drop down list populates data in another cell Amanda H 12/31/2008 5:26:04 PM I'm am creating a spreadsheet that has a drop down list to select a specific product and I want the selection from the list to automatically generate data for that product in another cell. For example: Cell A2 Drop down list will offer: Mirror 1 Mirror 2 Mirror 3 If Mirror 1 is selected I want a certain dollar amount to appear in cell D2. If Mirror 2 is selected a different dollar amount will appear in D2, etc. I've reviewed this link: http://contextures.com/xlDataVal02.html but I'm not sure that is what I am looking for. Any suggestions would be appreciated.

Re: drop down list populates data in another cell JBeaucaire <JBeaucaire.3lann5[ at ]thecodecage.com> 12/31/2008 5:41:33 PM That's a standard VLOOKUP formula. I presume you have a list somewhere with these items and prices? Try VLOOKUP in this format to specifically get the data: Sheet2=Column A - your items Sheet2=Column B - your prices Sheet2=Column C - item codes A1= your drop down selection (perhaps on sheet1) =VLOOKUP(A1,Sheet2!$A$2:$C$100,_2_,FALSE) -gets price =VLOOKUP(A1,Sheet2!$A$2:$C$100,_3_,FALSE) -gets item code -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=45527

Re: drop down list populates data in another cell "T. Valko" <biffinpitt[ at ]comcast.net> 12/31/2008 5:48:01 PM Same site, different technique: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Amanda H" <AmandaH[ at ]discussions.microsoft.com> wrote in message news:1947EFCE-3150-496B-AE63-1890F6F91FF2[ at ]microsoft.com... [Quoted Text] > I'm am creating a spreadsheet that has a drop down list to select a > specific > product and I want the selection from the list to automatically generate > data > for that product in another cell. > > For example: > Cell A2 Drop down list will offer: > Mirror 1 > Mirror 2 > Mirror 3 > > If Mirror 1 is selected I want a certain dollar amount to appear in cell > D2. > If Mirror 2 is selected a different dollar amount will appear in D2, etc. > > I've reviewed this link: http://contextures.com/xlDataVal02.html > but I'm not sure that is what I am looking for. > > Any suggestions would be appreciated. >