If range_lookup is TRUE or neglected, the main column must 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.Just as you are able to eliminate duplicates from any selected info in Excel, you can easily ge