Map3 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | Code | Name | Institute | |||||
3 | c_1 | a | std | |||||
4 | c_2 | b | log | |||||
5 | c_3 | c | rij | |||||
6 | c_4 | d | std | |||||
7 | ||||||||
8 | ||||||||
9 | Code | Name | Institute | |||||
10 | c_2 | b | log | |||||
11 | ||||||||
12 | ||||||||
13 | ||||||||
14 | ||||||||
Blad1 |
kapfrank said:Is it possible to put 2 possible dropdown in a sheet.
...
I have the following data C2:E6.
If i make a dropdown menu in B10 it's possible to fill in D10 and F10, with VLOOKUP (vert.zoeken = VLOOKUP).
But what if i want choose to select a Code (B10) or a Name (D10).
So when i make a second dropdown menu in D10 that B en F are filled in.
Is this possible?
can you have duplicates in the list
let say Paris in france and paris in USA
to my sense you would better start a thread for your specific problemhttp://www.ozgrid.com/News/excel-dependent-lists.htm#ExcelTips
When i try the example in the above mentioned site it works
when i try to recreate it mine wont work
I have excel 97