what is the best worksheet function to...
I have populated many cells in column A with the numbers 1 through 12. The
numbers are synonymous with the months of the year. However, I would like to
enter a formula in a cell in column B that looks at a cell in Column A,
determines which number is the cell and then populate the actual month in a
cell in column B. So if the number 12 was in cell A250, I would like the
formula B250 to look at cell A250, identify that it is populated with the
number 12 and then populate cell B250 with the word December. I would like to
run the formula on the entire list in Column A. So theoretically, each month
will appear in Column B because of the list of numbers 1 through 12 in column
A. How do I do this?
|