Unlike Find and Replace, the XMATCH function allows you to efficiently search for a value in a specific range or array, whether it's an exact match or the next smaller or larger value. You can ...