Using VLOOKUP() to combine information from different sheets

with No Comments

I www.excelguru.nooften 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 (358 downloads)