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

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

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