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