Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down list
Column A = numeric list 0-96
Column B = alphabetically ascending list of text I use a drop down list (numbers from A) in conjunction with a VLOOKUP (A and B) formula to populate a cell in a row. I have now inserted further options into B and have found that, because the numbers already picked from the drop down list now correspond to a different text value, Excel has updated the entire spreadsheet with the values which now correspond to the numbers. Bit long winded there. sry. How can I stop Excel doing this? -- Traa Dy Liooar Jock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |