How do I?
If cell B1 = 1001, I would like cell A1 to reflect "A".
If cell B2 = 1002, then cell A2 should be "B" and so on.
And if cell B1 = 1003, then cell A1 should be "C".
I need column A to read A,B or C based on column B being a value of 1001-1003.
Make sense?
TIA
Bill Bondo
|