If range_lookup is Legitimate or neglected, the 1st column must be sorted alphabetically or numerically. If the primary column is just not sorted, the return value could be a thing You do not expect. Either kind the 1st column, or use FALSE for an exact match.After you develop an Excel table with your worksheet, you can certainly insert or clear aw