If range_lookup is Correct or disregarded, the first column has to be sorted alphabetically or numerically. If the 1st column isn't sorted, the return value may very well be a little something You do not anticipate. Both kind the 1st column, or use Phony for an exact match. Lookups a spread o