consider the following sheet
ID Hours 1 16 2 24 3 50 4 36
now I need to match the values in Col B to one of 3 variables
16, 25, 30
so what I'm trying to do is match the number in B2:B to the closest number of the above three variables... not able to work this out with
=match... can anyone help?
adding a sheet for clarity:
Basically, what I want to do is assign a variable to a store based on their hours. so if ID 3 is 50 then they will be assigned the variable of 30 and have 20 left over, so essentially they have will two variables, one of 30 one of 16 with a remainder of 4. I've done this now with a few if/match statements but I was wondering if there was a one formula method to match one variable to another.