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)
B3: =LOOKUP($A3;$D$3:$D$8;$E$3:$E$8)
copy down
The column max is not needed. Indeed it is ambiguous for integer values.
Range problem suggestion.ods (25.7 KB)
The file contains three suggestions: Use combination of index and match, use lookup, use combination of index and roundup.
Thank you for the reply, but unfortunately it doesn’t solve my issue.
I changed a value without touching the function and it gaves me wrong results
What do you think the computer have to different between A or B if [A1] inherents 1,00? Or a value greater than 6?
added
Range problem_GS-v002_020057.ods (20.6 KB)
have a look to foglio2 test .5.
My trick is to reduce the input value to its integer, which is compared with each minimal value of the referenced list
Please study the LET function in depth, I wrote it in [P3], then dragged this cell to [P12]. You have to work with LO version 24.8 or newer.