vlookup

Associate
Joined
22 Jan 2006
Posts
460
spread2.jpg


basically need to get it to select an amount of staff to cover the amount of meals, and its choosing a lesser value, which is no good :s

any ideas?
 
This is horrible really but for now it works with the silly examples i have done. Also assumed for example that even 1 meal above 9000 would need 6 staff. As well as of course that your data wont ever change as you will have to type more nested if's the more you put into it!

microsoft_excel_-_book1-20071217-011152.jpg


Must sleep now :(
 
Back
Top Bottom