See Debra Dalgleish's site for how to create dependent Data Validation lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Tue, 4 Sep 2007 12:10:15 -0700, Mandy
wrote:

I am trying to create a formula and need help. What I am trying to do is
create a formula for my fantasy football draft. What I want is for the first
box to be like a dropbox type thing where I can put QB, RB, etc.. from there
if I pick QB then I want to be able to pick from a list of QB's in the next
box. If anyone could help me I would appreciate it. It has been a while since
I have had a class on excel!