I often get questions about how to use IF() to solve problems. In many cases the solution is not using IF() at all, but VLOOKUP(). In this example we collect information about employees from two different sheets using VLOOKUP().
Download the workbook here: VLOOKUP.xlsx (403 downloads)