| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link information form a dropdown list
I created a dropdown list for a 12 month budget with Tab "A" Budget & Tab "B"
Actuals. on tab "C" I created a dropdown list by month, but I need help to find the formula to link values from tab A,B when the month is selected from the dropdown list Dropdown list (Month) Budget Actual Formula xxxxx xxxxx Thank you!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link information form a dropdown list
Pivot table is the best option.
or use Sumprodut sreedhar "Alekata1422" wrote: I created a dropdown list for a 12 month budget with Tab "A" Budget & Tab "B" Actuals. on tab "C" I created a dropdown list by month, but I need help to find the formula to link values from tab A,B when the month is selected from the dropdown list Dropdown list (Month) Budget Actual Formula xxxxx xxxxx Thank you!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link information form a dropdown list
Pivot table is the best option
or Try Sumproduct With regards "Alekata1422" wrote: I created a dropdown list for a 12 month budget with Tab "A" Budget & Tab "B" Actuals. on tab "C" I created a dropdown list by month, but I need help to find the formula to link values from tab A,B when the month is selected from the dropdown list Dropdown list (Month) Budget Actual Formula xxxxx xxxxx Thank you!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link information form a dropdown list
i think first they all should be in one table on same sheet (tab) then you
can use vlookup formula to pick valuse with refernce to other. so that when you select a month it will give you budgets corresponding to that month "Alekata1422" wrote: I created a dropdown list for a 12 month budget with Tab "A" Budget & Tab "B" Actuals. on tab "C" I created a dropdown list by month, but I need help to find the formula to link values from tab A,B when the month is selected from the dropdown list Dropdown list (Month) Budget Actual Formula xxxxx xxxxx Thank you!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable dropdown list (Combo box -"Form control") | Excel Worksheet Functions | |||
| CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL | Excel Worksheet Functions | |||
| I want to link my order form with my data base list | Excel Discussion (Misc queries) | |||
| HOW TO GET DROPDOWN LIST TO LINK TO OTHER CELLS? | Excel Discussion (Misc queries) | |||
| Use dropdown list from Form | Excel Discussion (Misc queries) | |||
Linear Mode
