If range_lookup is Accurate or omitted, the main column has 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 primary column, or use Phony for an exact match.Equally as you can eliminate duplicates from any selected information in Excel, you can