If range_lookup is Legitimate or overlooked, the 1st column needs to be sorted alphabetically or numerically. If the initial column just isn't sorted, the return value may very well be a little something you don't count on. Both form the first column, or use Fake for an exact match.Once you generate an Excel desk as part of your worksheet, you can