Forum Discussion
Returning the range for a specific value
I'm not sure if this question has come up, but I'm trying to figure out how to look up a value in a source table and then return the nearest range value that is less than and greater than the value i...
umasirhc As a variant, similar but without helper columns and using XLOOKUP. So, only for MS365 subscribers! And I must say, it's not very elegant as the formula becomes too long to my liking.