Multiple drop menus in formulas
Hi there, i am using my mac os x 10.6.8 with Numbers 09 and am very new to creating formulas. I am using a template and am making my own alterations. As you can see in the pic attached i have one spreadsheet (transaction) that all information is entered and from there i want that information to be directed to the corresponding "account" gaph. Eg each graph is a seperate account, from the transaction spreadsheet i have drop down menus set up for each account and for each category. Am I able to have both account and category drop menu in the formula for the relative corresponding graph? Is there a way i can achieve this? Thank you for your assitance. L
MacBook Pro, Mac OS X (10.6.8), Automator