I have a column of form response numbers, and on a separate sheet a column of a random (but sorted) subset of those response numbers with another column next to it that has some scores.
I need to get the scores by looking up corresponding response numbers and returning blanks when it doesn't find an exact match.
I tried using LOOKUP, but
"If search_key is not found, the item used in the lookup will be the value that’s immediately smaller in the range provided. For example, if the data set contains the numbers 1, 3, 5 and search_key is 2, then 1 will be used for the lookup."
From here: https://support.google.com/docs/answer/3256570?hl=en
Seems like a horribly unintuitive default. Anyway, no use complaining.
Any ideas?