If range_lookup is Genuine or neglected, the first column has to be sorted alphabetically or numerically. If the 1st column isn't sorted, the return worth is likely to be one thing You do not expect. Either type the first column, or use Fake for a precise match.Observe: The (Blanks) Test box is out there provided that the range of cells or table c