VLOOKUP For Multiple Criteria On Multiple Sheets

[Dan1212]

Hello everybody,


I don't have much experience with VLOOKUP and INDEX functions. So any help at all is greatly appreciated.


I have a Totals sheet sorted from month 1 to month 12 and a separate sheet (BreakDown) to show the amount (in dollars) brought in from a certain type of procedure each month. In the Totals sheets there are many entries for procedures that took place and their individual dollar amounts.

The "type of procedure" is simply a code that ranges 1-14.


My question is, what would my VLOOKUP function look like to sum the amount brought in from each procedure for each month on a single cell in my BreakDown sheet.


So for example in my first cell (procedure 1, month 1) in the BreakDown sheet I would need to pull the info from my totals sheet for that month. And I would need the function to sum the amounts from procedure 1 in that first month.


Thanks

 

[MARZIOTULLIO]

Can you provide some sample data and what the expected outcome is?

 

[Dan1212]

Three example entries as follows:

Total Sheet:
Month 1, Procedure 2, $413.45 as the dollar amount
Month 1, Procedure 3, $124.37
Month 2, Procedure 3, $346.98

Procedure Type sheet:
(lists codes 1-14)

BreakDown sheet:

Month 1 Month 2

Procedure 1: -------- ----------
Procedure 2: (ex. $413.45). -----------
Procedure 3: (ex. $124.37). (ex. $346.98)



There are multiple Amount entries for each month and procedure, however.

Thank you.

 

[Dan1212]

Apologize for the format there. Month 1 and 2 are there to represent as column headers for the dollar amounts below

Thank you.