Auto Fill Cells, When Choosing From Drop-Down List...

D

doc1975

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 |
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down List Dependant Formula 2
Automatically fill cells when selecting from a drop down list 3
Drop down tabs that can auto fill certain information? 3
auto populate different cells when selecting from drop down list. 2
Drop down fill box does not appear when cell clicked. 1
Data Validation-pick from dropdown and next cell auto fills in inf 1
Remove blank cells from data validation drop down box 3
Drop Down List Expertise please! 10

Top