It’s 15 minutes before The Big Meeting and your co-worker comes to you in a panic. All the VLOOKUP functions in his spreadsheet are broken! Fix them for him before time runs out and save the day.

 

Instructions: start the challenge, download the attached spreadsheet (requires Excel 2007 or higher), fix the VLOOKUP functions, and answer the challenge questions before time runs out. Time limit is 15 minutes.