Hi Ron,


Read your answer to nabanco - just wanted to know what the( ,2,0 ) at the
end of the function represented ... the other bits I understand.

Kind regards
Finance Guru

"Ron Coderre" wrote:

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