So, to find which row has the employee in A10, you would use =MATCH(A10,$B$2:$B$6,FALSE) . Yes, this is more complex than Index, but it should be right up the ...
Excel Vlookup Index Match - Excel Tips - MrExcel Publishing
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.
