How do I find the closest lower value from another list?

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!

Try this procedure and see if it works for you.

Thank you so much for help!

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.