thing is, i need to be able to enter different numbers into the predicted meals table and have it adjust the staff table automatically. my problem is that vlookup chooses either an exact or lower value, i need it to choose the next higher so there is enough staff to cover
Instead of 9001 you can also point to a cell :
ROUND.UP( B4 / 4500 , 0) * 2
if you use index/match instead of v look up
if the data is sorted as descending
then setting the match type to -1
will return smallest value that is greater than or equal to match value
here's how its done
formula is in b2
i put the "if " bit in because it will find a match for nothing which is annoying
see example in g2
enter number dining in a2
Last edited by martindwilson; 02-23-2008 at 02:59 PM.
you sir, are a legend
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks