Is there a way in Excel to look for a numeric value in a non-continuous range throughout the table?
Please refer to the image below:
I need to search for the value 2 between the range minimum value and maximum value throughout the table. Here 2 lies in the range 1.93-2.286 so the displayed output will be 3rd. How is it possible?
Thanks in advance.