View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
yshridhar yshridhar is offline
external usenet poster
 
Posts: 229
Default 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!!