Because BigNum is an improbably large value, the lookup will find the previous numeric value.
In this (default) mode, MATCH assumes values are sorted in descending order.
For more details, see:Last row in numeric data.
BigNum
The term "BigNum", which stands for "Big Number", is used to represent the largest allowed positive number in Excel, which is 9.99999999999999E+307
