If range_lookup is Accurate or omitted, the main column must be sorted alphabetically or numerically. If the primary column is just not sorted, the return value could be anything You do not expect. Either kind the primary column, or use Wrong for an actual match.Observe: The (Blanks) Look at box is available provided that the range of cells or tab