 ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 321 guests online.
New Excel Experts
Current Excel / VBA Jobs |
drop down list that will fill and additonal cellI am trying to create a list in column A (thatt will be my drop down list) with a description in column B. In a new work book I want to select the item from the list and have it fill the next cell with the description. Can you offer advice on how to do this? Thank you, |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
please follow the steps given
please follow the steps given below.
go to new workbook
select the cells where you want dropdown to be created
go to DATA
click on data validations
in settings click on drop down of Allow tab and select list.
ignore blank & in-cell dropdown can be checked.
in source give the range where you have made a list from where you want data to be fetched in dropdown
now click ok.
now you can go to that cell and drag the formula until you need.
now you can select values form drop down
now do the vlookup to get the description against list.
drop down list that will fill and additonal cell
Dear Sir
Can you pls. share the one example in XL sheet and attach for our reference.