If range_lookup is Real or ignored, the very first column ought to be sorted alphabetically or numerically. If the main column is not sorted, the return worth could possibly be some thing you don't assume. Both form the first column, or use Untrue for a precise match.Equally as you could clear away duplicates from any chosen info in Excel, you can