punkin0601
New Member
- Joined
- Aug 16, 2005
- Messages
- 26
Is there a function or someway to write a macro to do the following?
On one sheet (called Balance), I have the account numbers listed in column A. On another sheet (called Inputs), I have the accounts numbers again with each month's balance in the columns next to it. On the 'Balance' sheet, I want it to look up the account on the 'Inputs' sheet and sum column F:P for the account and place it in the cell next to the account on the the 'Balance' sheet. Is there a way to do this with the 'VLOOKUP' function. Rather than have it return a value, I want it sum the columns in that row.
Thank you in advance for your help?
On one sheet (called Balance), I have the account numbers listed in column A. On another sheet (called Inputs), I have the accounts numbers again with each month's balance in the columns next to it. On the 'Balance' sheet, I want it to look up the account on the 'Inputs' sheet and sum column F:P for the account and place it in the cell next to the account on the the 'Balance' sheet. Is there a way to do this with the 'VLOOKUP' function. Rather than have it return a value, I want it sum the columns in that row.
Thank you in advance for your help?