dbailey705
New Member
- Joined
- Nov 21, 2005
- Messages
- 6
Hi
I am having difficulty figuring out how to proceed with the workbook I am creating. I have about 15 options I would like fill in a different cell depending on if the user chooses certain data. I tried to use IF but it only allowed me to give seven options then it would not allow any more choices to be made. Is there another way I can do this to allow all the options to be avialable?
For example, If I choose 1 of the 15 choices, the cell I choose will fill with the number I have associated with said choice. Again, it was working for the first few choices using IF but I still have other options that I cannot put in there because I am getting an error. Any help will be greatly appreciated.
Thanks
I am having difficulty figuring out how to proceed with the workbook I am creating. I have about 15 options I would like fill in a different cell depending on if the user chooses certain data. I tried to use IF but it only allowed me to give seven options then it would not allow any more choices to be made. Is there another way I can do this to allow all the options to be avialable?
For example, If I choose 1 of the 15 choices, the cell I choose will fill with the number I have associated with said choice. Again, it was working for the first few choices using IF but I still have other options that I cannot put in there because I am getting an error. Any help will be greatly appreciated.
Thanks