Excel Formulas

TradingRothIRA.com - IRA Investment Ideas, News and Stock Analysis Excel Templates!

Excel is a powerful program. However, Excel's powerful features are only as good as the person who can use it.

Now, you can make it more powerful by learning new Excel Formulas. Excel formulas for basic number crunching, as

well as more complex calculations such as payroll deductions, accounting or financial analysis.

Categories
Post Your Excel Questions
Free Excel Templates
Excel Course
Useful Resources
Search Excel Formulas

New Excel Formulas:

The MATCH( ) and INDEX( ) Formula

[Excel: Formulas]

Goal: Using the MATCH( ) function looks through a row or column of cells for a value and combine it with the INDEX( ) function that returns the value of a cell at the intersection of a row and column inside a reference. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003