The VLOOKUP function searches for the lookup_value in the leftmost column in the table_array and stops when the first match is found. But what if there are multiple entries in the table? Have a look at an example below: There are multiple “Kate N”s in the company. Using VLOOKUP, you will only get Start Date … Continue Reading
