Vlookup finding subtotals only

[deco]

I have the following:

Sheet 1 = Column A = account number (ex. 675000) = lookup_value

Sheet 2 = Column A-G subtotaled for Colunm A, by account = Table_array

Col_index # is for G (7)

My problem, sheet 1 column A is only the account #.

How can I have it find in sheet 2 the account subtotals?

It’s something to do with my sheet 1 account number since it doesn’t match
the table array “account # total†on sheet 2 for the lookup.

Thanks

 

[Pete_UK]

It's always useful to post the formula you have. I imagine it will
look like this:

=VLOOKUP(A1,Sheet2!A:G,7,0)

If you only want to get the subtotal row, then use this:

=VLOOKUP(A1&" Total",Sheet2!A:G,7,0)

Hope this helps.

Pete

 

[Eduardo]

Hi,
you can get the subtotal for each account from a sheet with the information
without the subtotals with the formula as follow in sheet1 column B

=sumproduct(--(A1=sheet2!$A$1:$A$1000),sheet2!$B$1:$B$1000)

I assumed that the column to summarize is column B from sheet2

 

[deco]

Thank you Pete, I'll remember to post my formula next time around.

The =VLOOKUP(A1&" Total",Sheet2!A:G,7,0) did the trick.

Thanks for your help

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thank you Pete, I'll remember to post my formula next time around.  

The =VLOOKUP(A1&" Total",Sheet2!A:G,7,0) did the trick.

Thanks for your help







- Show quoted text -

 

[Shane Devenshire]

Hi,

Here is another approach

=SUMIF(Sheet2!A1:A99,A1,G1:G99)