If range_lookup is Legitimate or neglected, the main column has to be sorted alphabetically or numerically. If the main column is not sorted, the return worth could possibly be some thing you don't assume. Both type the main column, or use FALSE for an actual match. If this option isn’t