Hello.
For several days I have been struggling with the puzzle of how to find a value equal to or closest to the lower value from another list.
For example, I have a result of 2.2 from the second list and I want to get the value from the first and third lists the same or the closest lower.
This is List 1: 1.4 and List 3: 2.2
Other times the result is 36 from list three, so I’m looking for list one and two, where the result should be (list 1) 32 and (list 2) 32
I would like to add that all three foxes are fixed (as in the photo) and do not change.
Please help!