link information form a dropdown list

A

Alekata1422

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

Hassan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Add additional information to excel form after original data entry 0
Auto Merge text from multiple sources 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Difficulty with compatibility mode and Track Changes 2
Dealing with the error: unable to filter on excel hc home school 0
list or combo box 0
Help with multi-level list 0

Top