VLOOK-UP Help

**dsheets05** · 10-07-2014, 05:40 AM

Example.xlsx

Hello Fellow Excel enthusiast,

Problem
I have attached a example spreadsheet with two tabs. One being a list of charges on one of my accounts
The other being my income statement. What I would like it to do is auto populate the income statement.

Example: On Cell B-10 on “Income Statement” I would like it to sum the amounts where the sub category is material and the month is January and the year is 2014. The value should be -9977.32.
I know this would be a sum lookup but have gotten an error or wrong data on everything I have tried. Been at it for about 4hours and am about ready to give up. Any help would be appreciated.

**dsheets05** · 10-07-2014, 05:50 AM

Thought I should clarify one thing... The amounts I am trying to sum are on the second tab.

**Richard Buttrey** · 10-07-2014, 05:53 AM

Hi,

If you do only have Excel 2003 then

In B2 enter the date 1/1/2014 (format it to show the text January) and similarly in C2:M2 enter the 1st of each month

B10:

Formula:

Please Login or Register  to view this content.

Otherwise with the later 2007+ the SUMIFS formula is much simpler

**samba_ravi** · 10-07-2014, 06:02 AM

find the attached file
=SUMPRODUCT(('Purchasing Account Balance'!$C$2:$C$378)*(TEXT('Purchasing Account Balance'!$A$2:$A$378,"MMMM")=B$2)*('Purchasing Account Balance'!$E$2:$E$378=$A10)*('Purchasing Account Balance'!$D$2:$D$378=LOOKUP(2,1/($B$1:$B9=""),$A$1:$A9)))
Try this formula in Cell "B10" and copy across