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