If range_lookup is Correct or left out, the 1st column has to be sorted alphabetically or numerically. If the very first column is just not sorted, the return worth might be a thing you don't be expecting. Either form the initial column, or use Phony for a precise match.Just as you'll be able to clear away duplicates from any selected knowledge in