Have a look here and see if this will do what you want

http://www.contextures.com/xlDataVal02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"rdlchapman" wrote in message
...
I'm trying to combine the IF function and a pull down list.

I've tried typing in the following

IF(A2="forward left","LISTnextstep","")

As a means of answering the question and leading onto another drop down
list.

Can anyone point out any problems?

Many thanks