Using VLOOKUP with an IF statement, is this right?

[kbsacto]

Hi All!
I'm new here and pretty much an Excel novice. I'm looking for advice (or reference to another thread) regarding a VLOOKUP and IF statement formula.

Background
I complete a report every month. I get data for this "dashboard" report from several different sources. I have figured all out but one. On my dashboard sheet I need to be able to extract specific data from another sheet whose columns are consistent but rows may change.
I am currently doing this manually and I know there's a formula out there that can make my life easier I just don't know how to get started. I've tried putting the VLOOPUP and IF statement together without success.

I hope this makes sense. I'm officially at the end of my rope.

I attached a sample document that I hope will clarify...

Thanks in advance!

Sample Excel.xlsx

[hoyasaxa215]

What's your desired outcome? Can you provide a couple examples?

[kbsacto]

My desired outcome is to return one (or sum) value based on a couple of different variables.

Example:
I need to know what the total quantity of items sold from sheet 2 and put it on sheet 1 for a specific store and specific department.

Honestly I don't know if I'm explaining it properly..

[hoyasaxa215]

Had to change some of the column headings to be consistent. Let me know if this is what you were looking for.

[JohnTopley]

Another version using SUMPRODUCT

=SUMPRODUCT((Table1[Quantity sold])*(Table1[Store]=$A2)*(Table1[Department]=LEFT($B$1,7)))

Changed heading to "Books" rather than "Book"

See attached.

[kbsacto]

Unfortunately the headings have to be different because of the requested dashboard. It seems like these two versions would work but it would take about the same amount of time as referencing a cell on another sheet. It's possible that I'm such a beginner that I don't completely understand the formulas enough to recreate them. Thanks for your help!