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

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.

In such scenarios, you may use the Find and Replace feature. For the above example, this works as follows: Excel will alert you with the number of replacements made in the entire sheet or the ...

This can ruin a beautiful excel model. And it can take awhile to fix because you have to find the problem cell. The F5 key saves time in Excel by letting you jump to specific cells or named ranges.