If range_lookup is TRUE or neglected, the 1st column needs to be sorted alphabetically or numerically. If the initial column just isn't sorted, the return value could be anything You do not expect. Either kind the 1st column, or use FALSE for an exact match. Lookups a variety or an array and