Microsoft Excel is one of the most useful programs ever developed in the history of computing. One function that anyone looking to master the spreadsheet program needs to know is VLOOKUP.

If you want to find the price of a particular product like "Tablet," you can use the following formula: =LOOKUP("Tablet", ...

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...