Use DataValidation, type of List, with a formula of

=IF($A$1=2418,list1,list2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tdahlman" wrote in message
...
I want to use a listbox for a cell. But I want to have 2 different lists
to
choose form based on what a certain cell is. EXAMPLE in cell A2 I want to
have a list box. Now if A1 shows "2418" then I want A2 to have a list
showing
different options. And if A1 shows "2499" then I want A2 to have a list
with
different options. Is this possibe? if so, how do I do it.
Thanks in advace

Travis