When I enter an employee ID, Excel will automatically tell me the employee's name (using the VLOOKUP function), the total number of weeks ... ID into cell H7 to get us started.

Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula.