If range_lookup is Legitimate or disregarded, the main column needs to be sorted alphabetically or numerically. If the first column isn't sorted, the return worth may very well be one thing you don't count on. Both type the 1st column, or use Bogus for an exact match.Equally as you'll be able to remove duplicates from any chosen info in Excel, you