Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if worksheet function | Excel Worksheet Functions | |||
VBA worksheet function | Excel Discussion (Misc queries) | |||
Worksheet name in function | Excel Worksheet Functions | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Can the offset worksheet function reference another worksheet | Excel Worksheet Functions |