Lookup, VLookup, HLookup

First, let me thank in advance. I have had great answers when posting.
Here is what I want to do:

I want Excel to look on the IRR sheet, find Department 10, find the cell that has Curr YR Current Month Purchases – Retail, and put that number on the TLE sheet in cell C3.

The information on the IRR sheet will not be in the same order all the time, that’s why I want it to it this way.

I have attached what I am working on.