| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drop down list
Do you have ,False) at the end of your VLOOKUP function, to force an exact
match? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jock" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drop down list
No, but that said, the VLOOKUP formula is returning the correct (new) value.
I think the easiest way around this is to add new items to the end of the list and re sort it at the end of the year. Thanks though Bob -- Traa Dy Liooar Jock "Bob Phillips" wrote: Do you have ,False) at the end of your VLOOKUP function, to force an exact match? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jock" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
