Dears,
i create drop list by using data validation + used Vlookup (VLOOKUP(cell of drop list;the below range;2;FALSE) :
<tbody>
</tbody>
<colgroup><col width="64" style="width:48pt"></colgroup><tbody>
</tbody> it's working fine ((( when i select A number 1 appears and so on ))) but i need when select ALL (all data in column 2 appears )
<tbody>
</tbody>
i create drop list by using data validation + used Vlookup (VLOOKUP(cell of drop list;the below range;2;FALSE) :
E | drop list ( i need used "All" ) |
5 | vlookup ( i need all numbers appears ) |
<tbody>
</tbody>
<colgroup><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>
all | |
A | 1 |
b | 2 |
c | 3 |
d | 4 |
e | 5 |
f | 6 |
<tbody>
</tbody>