| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a number to select cell location
I am trying to create math worksheets for my students so that the words for
numbers can be substituted automatically. I have my word list in column A and prepared a work sheet so that I can place numbers in one column say B and would like the words to auto fill in column C. I have used the IF statement however it is severly limited by 7 statement only. Is there a way to define which cell in column A to obtain the word for column C by using a value in column B? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| select cell based on a number in another cell | New Users to Excel | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
Threaded Mode
