Hi!

Try this in cell B28:

=VLOOKUP(A28,Bios!A2:C4,3,0)

Biff

"doc1975" wrote in
message ...

What i am looking to do is in cell A28 (which is a drop-down list
comprised of cells A2-A27) when someone selects a person from that
list, cell B28 auto fills with the corresponding cell in column C,found
on the sheet labeled Bios. As you can see i have tried doing it with
the IF function, but have realized that it has a limit as to how many
if functions you can perform. Any help in the matter would be greatly
appreciated. Please take a look at my example excel workbook.


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4207 |
+-------------------------------------------------------------------+

--
doc1975
------------------------------------------------------------------------
doc1975's Profile:
http://www.excelforum.com/member.php...o&userid=30337
View this thread: http://www.excelforum.com/showthread...hreadid=500005