Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to add a drag-down list box in Excel
does anyone know how to add a drag -down list box and if I choos a from my
list, it will give 1 to cell B1, If I choose b from my list, it will give 2 to the same cell B1, and so on. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to add a drag-down list box in Excel
All you have to do is use data validation for the drop down box in A1 and
then in cell B2 use =LOOKUP(lookup_value,lookup_vector,result_vector). "lili" wrote: does anyone know how to add a drag -down list box and if I choos a from my list, it will give 1 to cell B1, If I choose b from my list, it will give 2 to the same cell B1, and so on. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Val list Excel 97 fire macro | Excel Discussion (Misc queries) | |||
Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions |