Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
The third parameter indicates the index of the target column in the table. As we are searching in the Sales Person column,[JS1], the value of this parameter should be 4 range_lookup — This is an optional parameter to specify the type of search. You can set it to TRUE for an approximate match