Lookup formula

[punkin0601]

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?

 

[fairwinds]

Hi,

Assuming the account numbers are listed in column E in input sheet, try:

=SUM(INDEX(Inputs!$F$2:$P$100,MATCH(A2,Inputs!$E$2:$E$100,0),0))