Using a list as an IF answer
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 |
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 |
All times are GMT +1. The time now is 03:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com