i have data keyed by user into cells in column B, dependent on which column C
should autofill its corresponding cell with one of several things.

if col b cell equal any of the following values i need corresponding column
C cell to show "R2PF"

41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 61, 62, 63,
64, 65, 68, 70, 75, 78

if col b cell equals any of the following values i need corresponding cell
in C to Show "R2FL"

1, 2, 3, 4, 5, 6, 7, 8, 11, 12, 14, 31, 32, 33

if col b equals any of the following values i need corresponding cell in C
to show "R2FF"

69, 71, 72, 73, 74, 76, 77, 84, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99

if col B equals "bulk" i need c to show "CHQU"
if col b equals "CANADA" i need c to show "CANADA"
if col b shows "sample" i need c to show "RPQS"
if col b shows "B-1" i need c to show "RPGK"

also, can the time that column b cell is entered into be stamped into
corresponding cell in column M?

any help greatly appreciated.


--
Tim