Use the LOW END numbers of the ranges in a lookup..
=LOOKUP(A1,{0,101,201},{1,2,3})
Hope that helps.
Use the LOW END numbers of the ranges in a lookup..
=LOOKUP(A1,{0,101,201},{1,2,3})
Hope that helps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks