If range_lookup is Accurate or omitted, the first column has to be sorted alphabetically or numerically. If the 1st column is just not sorted, the return value may very well be a thing You do not expect. Either type the 1st column, or use FALSE for an exact match.Be aware: The (Blanks) Examine box is offered only if the variety of cells or desk co