Thread: Excel Help
View Single Post
Old 02-24-2006, 10:53 AM   #5
Eagle Eye
Powerplay Quarterback
 
Eagle Eye's Avatar
 
Join Date: Sep 2002
Location: Work
Exp:
Default

Ahh I see what you are saying.

Sorry misread your post

yup that would return the first value from a list

Try this I used a nested if statement in the drop down list setup

I named the first list "team" the second list "Type' and the third list "number"

Depending on the value I select in Column F (a list) I will get a different list to pick from


Last edited by Eagle Eye; 02-24-2006 at 11:07 AM.
Eagle Eye is offline   Reply With Quote