Here's an example of how to do that:

Sheet2, cells A1:B5 contain this list:
Alpha Maple
Bravo Oak
Charlie Ash
Delta Pine
Echo Cherry

On Sheet1
A1: Charlie
B1: =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,0)

In that example, B1 returns: Ash

For more information on using VLOOKUP and lists see this website:
http://www.contextures.com/xlFunctions02.html

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"nabanco" wrote in message
...
Hello,

Is there a way to automatically fill data from a list.
For example, if I typed Denver in cell A1, the sheet would automatically
put
in "Broncos" in cell A2.

Trying to enter one of a series of names of people, and their manager's
name
would automatically appear.

Thanks for your help