Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting drop down list selection to data
I am trying to create a formula that will automatically insert data when
item(s) are selected from drop down list. Drop down list is text based, while data is numerical. Help please!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting drop down list selection to data
You need to supply more information. Is the dropdown list a data validation
list or a drop down combo box? Perhaps an example of the data in the dropdown list and an example of what you want the answer to be etc. -- Regards, OssieMac "hypnogic" wrote: I am trying to create a formula that will automatically insert data when item(s) are selected from drop down list. Drop down list is text based, while data is numerical. Help please!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting drop down list selection to data
it is a data validation drop down list -- and each entry has a series of
different row values. I'd like these row values to auto-generate by simple selection of the drop-down list item. I've unsuccessfully tried goal seek, choose, if and value functions. I'm lost!!!! I have the idea but not the wording. Thanks for your input. :) "OssieMac" wrote: You need to supply more information. Is the dropdown list a data validation list or a drop down combo box? Perhaps an example of the data in the dropdown list and an example of what you want the answer to be etc. -- Regards, OssieMac "hypnogic" wrote: I am trying to create a formula that will automatically insert data when item(s) are selected from drop down list. Drop down list is text based, while data is numerical. Help please!!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting drop down list selection to data
If your droplist in column A and you make a choice in A2, you want B2 and C2 (etc) to go grab some matching date to A2 and fill it in? Like prices and rates and availability and such? This is a standard VLOOKUP formula. If the sheet holding the data you want to pull information from is on Sheet2, let's say Text Desc in column A and prices in Column B. On Sheet1, your validation list of descriptions is in cell A2. In B2, this formula would pull over the matching price: =VLOOKUP(A2,Sheet2!$A2:$B$100,2,FALSE) If there were date in column C you wanted, the formula for C2 would be =VLOOKUP(A2,Sheet2!$A2:$C$100,3,FALSE) Press F1 and readup on using the VLOOKUP formula. hypnogic;174981 Wrote: it is a data validation drop down list -- and each entry has a series of different row values. I'd like these row values to auto-generate by simple selection of the drop-down list item. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48377 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting drop down list selection to data
Thanks much! This was the missing piece. Much gratitude your way.
"JBeaucaire" wrote: If your droplist in column A and you make a choice in A2, you want B2 and C2 (etc) to go grab some matching date to A2 and fill it in? Like prices and rates and availability and such? This is a standard VLOOKUP formula. If the sheet holding the data you want to pull information from is on Sheet2, let's say Text Desc in column A and prices in Column B. On Sheet1, your validation list of descriptions is in cell A2. In B2, this formula would pull over the matching price: =VLOOKUP(A2,Sheet2!$A2:$B$100,2,FALSE) If there were date in column C you wanted, the formula for C2 would be =VLOOKUP(A2,Sheet2!$A2:$C$100,3,FALSE) Press F1 and readup on using the VLOOKUP formula. hypnogic;174981 Wrote: it is a data validation drop down list -- and each entry has a series of different row values. I'd like these row values to auto-generate by simple selection of the drop-down list item. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48377 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique drop Down List Selection | Excel Discussion (Misc queries) | |||
MAtch drop down list selection to data sheet | Excel Worksheet Functions | |||
Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions | |||
Print each drop-down list selection | Excel Discussion (Misc queries) | |||
quick selection drop down list | Excel Worksheet Functions |