You didn't say what the bucket sizes were supposed to be.
However, a guess.
=LOOKUP(A2,$G$2:$G$5,$H$2:$H$5)
In the lookup table, the number on the LEFT is the STARTING point for that "bucket" and the term on the right is its description.
You didn't say what the bucket sizes were supposed to be.
However, a guess.
=LOOKUP(A2,$G$2:$G$5,$H$2:$H$5)
In the lookup table, the number on the LEFT is the STARTING point for that "bucket" and the term on the right is its description.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks