Forum Discussion
Solved
Provide a Value when number is within a specific range (min-max) in other columns
Hi there, I am trying to get a result in column B taken from values set in column D, based on number in column A. In column A there are numbers within ranges set in min-max columns E and F. I am atta...
Your Min and Max values overlap: 45 is both Red and Blue.
Change like this:
Formula in B4:
=XLOOKUP(A4:A9, E4:E8, D4:D8, "", -1)
(Undoubtedly, it is also possible to use a combination of BYROW and LAMBDA 😁)
I don't see an example...