KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have workbook with 2 worksheets. "Sheet2" has two columns: | A | B | +---------+---------------+ | code1 | description 1 | | code2 | Descr 2 | Sheet1 has several columns, one of them (column D) is code . In this column i need a "drop box", what will show column Sheet2!B (the descriptions), and when the user selects one description will enter the code from the col:A. It is possible to do without additional helper column in Sheet1? (Excel 2010) So, need something what is dead simple in html: <select> <option value="code1">Description 1</option> <option value="code2">Descr 2</option> </select> when when the user selects "Descr 2", the form get "code2". This question probably is an duplicate - but i'm not sure - to: How to create dropdown with multiple columns in excel , but the only answer to it pointing me to an external site where the solution is for another problem. Added a screenshot for more precise explanation:
Tags (comma-separated)
Save Edits
Cancel