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