Multi variable return data between two sheets INDEX

[jespo1351]

Okay, I am looking for a formula to pull the information from the DATA tab to the RESULTS tab. For example, I need the Results tab formula in cell B5 to search for the quantity on the line that matches April-15 Total for ITEM# 000045. I have used and index match formula but I am not sure how to have a formula search to two specific things ("April-15 Total" AND "000045") on any line. Any help would be greatly appreciated. Excel 2007

Thanks

[FDibbins]

Seeing as you have subtotals in there, I would use sumifS() instead of index/match....
=SUMIFS(DATA!$C$2:$C$31,DATA!$A$2:$A$31,Results!A4,DATA!$B$2:$B$31,Results!$A$3)

The equivalent INDEX/MATCH would be something like this would get really complex, counting matching dates with item #

[sktneer]

Try this.....

In A5

Please Login or Register  to view this content.

and copy across.

[jespo1351]

Thanks sktneer and FDibbins!

I have played with both of them on the big spreadsheet that I have and the IFERROR one seems to be the most practical one to match my needs. This will save me a great deal of time! You guys are terrific!

[sktneer]

You're welcome. Glad we could help.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

[FDibbins]

Glad you got what you needed, thanks for the rep