Problem filling a cell

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
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
HI

What are the selection / output combinations? Maybe VLOOKUP???


Tony
 

dbailey705

New Member
Joined
Nov 21, 2005
Messages
6
In the first worksheet I have the product we run in columns and the days of the week in rows along with each of the shifts (1st, 2nd, 3rd) . What I am trying to do is If the person imputing data on the first sheet inputs the number 50 for a certain product on a certain day, I want that information to go to anthor worksheet that has a schedule for the day

I tried to do this using IF and it worked for a few but then it wouldnt let me put all the choices I need to have. ( We run about 25 different product so I need to have at least that many options). I hope this helps clear it up. I am stumped!

Thanks
 

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
HI

Can you post up a sample of your layout and expected output for a given example.


Tony
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,008
Members
412,304
Latest member
citrus
Top