Good Evening Everyone,

First I want to thank everyone for all the great information that is here.
Now my problem, I have a worksheet that is a status report for jobs we have, there is one column that gets a number code.
What I am trying to do is have one of the next 6 cells get a date stamp based on the value in column in A.
So if A = 1, I would like a date stamp in column B
If A = 2, I would like a date stamp in column C,
If A = 3, I would like a date stamp in column D, etc.
But it should not change any of the previous date stamps.
The next part is that I want to be able to use that date stamp like:
3 would stand for "completed" so in a table I could use VLOOKUP so:
A1&" "&D1 (Completed 8/7/12)

Thanks