LinkedIn Facebook Twitter Gmail Among many misconceptions about the VLOOKUP function is that it cannot return items repeated n times. This is not true! For example, Using the data below, can you return the names of the customers who have bought 3 times using VLOOKUP? Here are the steps: Create a helper column that counts … Continue reading How VLOOKUP Returns Items Repeated N Times