If range_lookup is Accurate or ignored, the primary column has to be sorted alphabetically or numerically. If the very first column just isn't sorted, the return benefit may very well be one thing You do not count on. Possibly sort the initial column, or use Wrong for an exact match.Note: The (Blanks) Examine box is out there provided that the ran