If range_lookup is Legitimate or overlooked, the 1st column needs to be sorted alphabetically or numerically. If the primary column is just not sorted, the return value could be a thing You do not expect. Either kind the 1st column, or use Phony for an exact match.Take note: The (Blanks) check box is accessible only if the array of cells or table