If range_lookup is Correct or ignored, the first column has to be sorted alphabetically or numerically. If the 1st column is just not sorted, the return value could be anything You do not hope. Either sort the initial column, or use Wrong for an actual match. Note: The (Blanks) Verify https://wm78976420.blog5.net/73769930/wm-an-overview