Hi Howard,

Yes, just a different formula format

=IF(E1="A",letters,IF(E1="B",numbers,costs))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"L. Howard Kittle" wrote in message
...
Hi Bob,

Pretty slick. Is there a way to do more than two lists with this method?
I
tried this and it did not work, validation would not accept it.

=IF(E1="A",letters,numbers),IF(E1="C",costs)

Regards,
Howard

"Bob Phillips" wrote in message
...
I wouldn't use the method Ron points to, it bis too complex for this
requirement IMO.

Instead, this is my suggestion. Assuming list i is in E1, and the other
lists are named ranges called numbers and letters, in the second
dropdown,
use an allow value of List and a formula of

=IF(E1="A",letters,numbers)

just change all the usual suspects to suit your siutuation.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"kd" wrote in message
...
I use Windows XP.

What I need to acheive is, when a value is selected from a drop down
list,
to return another dropdown list which matches the criteria, Ex. 1st
list
has
2 options, A&B and if A is selected return dropdown list which is
related
to
A. Hope this explains...