In the first sheet shown below: SHEET 2133

http://tinypic.com/r/f1jcc4/5 (SEE LINK, photo would not post; sorry)
Box A12 is where the formula would need to go.

Ideally, I want the 100-299 CCF (A12) along with the 300-499 CCF, etc to populate the number that I manually typed into the ACCEPTED SHEET that coorseponds with their code.

http://i44.tinypic.com/30thnxv.png (SEE LINK, photo would not post; sorry)

So, to better explain...

I want the formula to:

1 - find if CODE 2133 is in SHEET ACCEPT from B3-whatever the number is for that week and then that persons total which would be in the cooresponding C-box.

If I have to change the way the layout is on the ACCEPT sheet to make it easier, I can do do...but just don't know where to start.

Thank you in advance!!!!! Any help or suggestions are appreciated.

I can post the full file if neccessary.

Thank you in advance