Not sure what to do(Stuck)

[sshanahan19]

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

[carsto]

In A12
IF(ISERROR(MATCH(C1,Accept!B:B,0)),"",INDEX(Accept!C:C,MATCH(C1,Accept!B:B,0),1))

(You'll have to fix the sheet names)

1. figure out how to attach a workbook
2. if I was a moderator, I'd have to jump you for double posting on our own board & using a nondescript title

[arlu1201]

Please change your thread title according to forum rules.