Excel drop down menus
Alright so my question is how do you create a drop down list that once an
item is selected it will automatically fill in the rest of the information for you? For example Say in a drop down list you select a persons name. After I select their name i want their address to fill into the address area below. Anyone know how to do that????? Thanks! -- P |
Excel drop down menus
You would need to create a formula like a VLOOKUP that takes the selected
value and uses it in the VLOOKUP http://www.contextures.com/xlDataVal01.html http://www.contextures.com/xlFunctions02.html -- Regards, Peo Sjoblom "Paetra" wrote in message ... Alright so my question is how do you create a drop down list that once an item is selected it will automatically fill in the rest of the information for you? For example Say in a drop down list you select a persons name. After I select their name i want their address to fill into the address area below. Anyone know how to do that????? Thanks! -- P |
All times are GMT +1. The time now is 03:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com