using a number to select cell location

Giganews Newsgroups
Subject: using a number to select cell location
Posted by:  Trevor
Date: Thu, 29 Jun 2006

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?

Replies