Number and text in same cell

Hi

I need a formula to do the following example


A2.....6 Steven..........B2.....1..........C2....."blank"
A3.....2 Gary.............B3.....2..........C3.....2
A4.....4 Luke.............B4.....3..........C4....."blank"
A5.....5 Paul..............B5.....4..........C5.....3
A6.....1 George..........B6.....5..........C6.....4
A7.....3 Adam............B7.....6..........C7.....1

so i need C cells to look if the A cells have a certain number in B cells then give it a number in C cells according to the order

also if possible i'd like the data above in "A" to be on another sheet eg. "A" on sheet1 and "B & C" on sheet2

hope this made sense

thanks in advance

jamie