Hello,
I have never used this funtion before. Not sure if this is even the right one. But here is what I am trying to do.
I have data on one worksheet (say deposits). The payee names, their job titles and payout amounts are on this worksheet. I have another worksheet which maps the job titles to the department of the payee.
I need a way to report payouts by department.
Any assistance is greatly appreciated.

Regards
Me