One function that anyone looking to master the spreadsheet program needs to know is VLOOKUP. It's easily one of the handiest ways to sort through and understand large reams of data. Here ...

To do this, I will type the following formula into cell H2 ... if you have a directory of phone numbers and people's names, using VLOOKUP to find the phone number based on the name you input ...

Excel's VLOOKUP function is similar to a telephone book. You provide it with a value to look up (like someone’s name), and it returns your chosen value (like their number). VLOOKUP might seem ...