Maybe =vlookup() or =index(match()) would be what you want.

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

Gomer Pyle wrote:

I want to be able to autofill a cell by typing a number and having the next
cell autofilled with information from another worksheet.

--

Dave Peterson