"I often hear the name VLOOKUP function, but honestly, I don't really understand it..." "I was told it's a function I should learn, but it seems difficult to use." "I ...

Following on from our time saving Excel shortcuts, we continue offering updated advice for the time-sensitive spreadsheet enthusiast. Back in 2013 John Gagnon wrote a very popular post about VLOOKUP ...

It would be a lot of work to manually type in names every time you create a name list or a seating chart. You might even make a typo when entering names. Let's set it up so that the name is displayed ...