If range_lookup is TRUE or omitted, the main column must be sorted alphabetically or numerically. If the primary column is just not sorted, the return value is likely to be one thing You do not hope. Either sort the initial column, or use Wrong for an actual match.Equally as you may take away duplicates from any chosen info in Excel, you can easily