For more than 2 or 3 I like to use Choose. You can have up to 29 ranges. (29
reference arguments in Choose)

=CHOOSE(MATCH(A1,J1:L1,0),Letters,Numbers,Costs)

Choose can also handle dynamic ranges where Indirect can't and the
"standard" workaround is "unecessarily overly complex" (IMO)

Biff

"L. Howard Kittle" wrote in message
...
Thanks for the info. That was the format I was trying to remember, having
seen
it many times in other solutions. With two IF's you get three egg rolls.

I should have been more concise and asked how do you do, four, six, or
eight?

Thanks,
Howard

"Bob Phillips" wrote in message
...
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...