VLOOKUP with approximate match returns wrong value

[swmal]

VLOOKUP with approximate match (range_lookup TRUE or omitted) can return an incorrect value or 0. The binary search runs over a trimmed range with all blank cells removed, shifting the midpoints so the result differs from Excel, especially on unsorted data containing blanks.