i need help with formula
 

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!

i need help with formula
 

see:

http://www.contextures.com/xlDataVal02.html


--
Gary''s Student - gsnu200742


"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!

i need help with formula
 

Take a look he

http://www.contextures.com/xlDataVal02.html

"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!

i need help with formula
 

Thank you very much! It helped out and answered my question!

"Toppers" wrote:

Take a look he

http://www.contextures.com/xlDataVal02.html

"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!

i need help with formula
 

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!