VLOOKUP For Multiple Cells in Separate Sheet

[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 each procedure 1 that occurred in the first month.

Thanks

 

[SharperSheets]

Could you post your sheet. I don't know if i quite follow what you mean. is there a unique id linking the two sheets?