Lookup Function brings back value to the right of result vector when it finds the next match in list? And no it has nothing to do with absolute values. Already checked.
Lookup performs an approximate match and assumes that the search vector is sorted in ascending order. A better alternative could be using Vlookup with exact match as shown in attached file.
