Written by Returns values from the result range corresponding to the location of a found match in the lookup range. If a match isn’t located, it delivers the nearest match instead.
Fetches a single value from a database-like range or array using a SQL-style query.