Using a scrollbar in the sheet
with No Comments

Using a scrollbar in Excel In this example we demonstrate the use of a scrollbar to scroll through a list of names. We also use IFERROR(), VLOOKUP(), MATCH(), COUNTIF() and a bit of VBA coding.   Download the workbook here: 

Using VLOOKUP() to combine information from different sheets
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(). Download … Read More