using a number to select cell location

T

Trevor

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?
 
G

Gord Dibben

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
 
Top