| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a number to select cell location
Trevor
See help on VLOOKUP Basically you have a list of numbers in a column and in an adjacent column a list of words corresponding to those numbers. 1 one 2 two 3 three =VLOOKUP(C1,$A$1:$B$3,2,FALSE) entered in D1 Enter a number in C1 and D1 will return the word. Gord Dibben MS Excel MVP On Thu, 29 Jun 2006 14:39:02 -0700, Trevor wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using a number to select cell location
Beautiful....thanks a lot Gord. Works perfectly.
Trevor "Gord Dibben" wrote: Trevor See help on VLOOKUP Basically you have a list of numbers in a column and in an adjacent column a list of words corresponding to those numbers. 1 one 2 two 3 three =VLOOKUP(C1,$A$1:$B$3,2,FALSE) entered in D1 Enter a number in C1 and D1 will return the word. Gord Dibben MS Excel MVP On Thu, 29 Jun 2006 14:39:02 -0700, Trevor wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
