Howdy!
I am having problems with the lookup… if I have two values in my lookup table, “1 second” and “10 seconds”, it matches the first value when it should be matching the second value.
What am I doing wrong? Thanks!
- d
Not giving a reduced spreadsheet where we can see, what you tried, reduces answers to the clairvoyant residents here. IMHO this is your second error.
.
Blind shot from my side:
“The vector to be searched must be sorted, as described in the #Additional details: section below,”
is quoted from Documentation/Calc Functions/LOOKUP - The Document Foundation Wiki