Hi everyone,
I’m having an issue on finding a way to do what i want.
To make it short, i have two ranges (min and max) in column D and F.
In column è there is “name”, and in column A the values.
What I’m trying to do is to have the “name” in column B next to the right value.
Example:
Cell A7 = 5,18
Cell B7 = Cell E8 = F
I tried with the function INDEX and DB but i think I’m missing/forgetting something
Attached a short version of the original file
Range problem.ods (10.4 KB)