Hello, I'm having trouble with 2 way lookups in tables.
I have 2 tables
One has expenses and their budgets each month.
The other has different types of spending patterns by month.
I need to multiply the budget by the month's spending percent according to it's Spending Pattern. I have a working formula in one column, but I need to drag it across all the months. I want to use a formula that I can drag across months, as we have several other tables of data. I always have problems dragging formulas across months when I use tables. Am I missing a way to use absolute and relative references between tables and columns??
Also, I'm using Excel 2010
Thanks for the help! I hope I was able to explain my problem correctly!
Joe
Bookmarks