| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| Prefill cust info from drop list into other cells | Excel Worksheet Functions | |||
| How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
| Auto Fill using a list of students | Excel Discussion (Misc queries) | |||
| Formatting cells Auto fill color using €œIf€ | Excel Worksheet Functions | |||
Linear Mode
