Using VLOOKUP() to combine information from different sheets

by ketil on December 6, 2014 with No Comments

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().