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 😁)
So I've uploaded the file to the website and sent a reply yesterday, but it was not approved. I understand the restriction for new users, but honestly I'm not sure how I can send the issue to you without this ability. I will try one more time using a screenshot, maybe this can go through.
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 😁)
That did it! Thanks a million! ❤️