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 😁)
Hey, thanks for the answer, I would like to attach the file to better show what I mean but when I try to do so the website claims the file is not allowed (it's .xlsx), do you happen to know why that is?
That's limitation of this resource. Files attachment is allowed only for user who have some history of activities here, not sure about exact limitations. Alternatively you may publish the file on any other resource ( OneDrive, whatever), make it available for everyone and share the link.