=LOOKUP(Wizard!B4,{"Annually","Monthly","Hourly";annual cost, monthly cost, hourly cost})
This is the formula I am using. The front page has two drop down menus. One with the number of users, and one that is the time frame (above). The goal is to be able to select the number of users, and the time frame, and have the whole document change accordingly. The users menu was easy, as it was all numbers that worked together. I tried a similar function for the text, and it works for 2 of the 3 options. It recognizes Monthly, and Annually, but then puts down numbers for annual cost once Hourly costs are selected in my "Wizard." Is there another formula? or is it formatted wrong? Please help! It's almost finished and there is only one variable that isn't cooperating!
-
Need to make numbers react to all text variables. Not just most of them
-
Thanks!
This is the formula I am using. The front page has two drop down menus. One with the number of users, and one that is the time frame (above). The goal is to be able to select the number of users, and the time frame, and have the whole document change accordingly. The users menu was easy, as it was all numbers that worked together. I tried a similar function for the text, and it works for 2 of the 3 options. It recognizes Monthly, and Annually, but then puts down numbers for annual cost once Hourly costs are selected in my "Wizard." Is there another formula? or is it formatted wrong? Please help! It's almost finished and there is only one variable that isn't cooperating!
-
Need to make numbers react to all text variables. Not just most of them
-
Thanks!
