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?

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?

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?