If range_lookup is Correct or disregarded, 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 little something you don't anticipate. Both form the first column, or use Fake for a precise match.Notice: The (Blanks) Test box is on the market provided that the num