|
Auto Fill Cells, When Choosing From Drop-Down List...
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 |
Auto Fill Cells, When Choosing From Drop-Down List...
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 |
| All times are GMT +1. The time now is 02:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com