Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
exact match, -1 is for the closest match above the lookup value, and 1 is for the closest match below the lookup value. We set it to 0 After putting all the parameters, the below function is formed: =MATCH("Sales Person",B3:E3,0) In the VLOOKUP function, just replace the column_index_num parameter