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!!

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!!

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!!

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!!