With a formula like VLOOKUP(Z2,A2:B100,2,0) where A2:A100 is sorted ascending and there are multiple matches, it appears, with very limited testing, that the match is always the first in the range. Is this always true? I would think that a binary search would be occurring which may not always...