Indexes

Resolved · Low Priority · Version 2003

Mon 30 Mar 2009, 11:40 Delegate Simon said...

Simon has attended:
Excel Advanced course

Indexes

How do you use index formulas?

Thu 2 Apr 2009, 14:19 Trainer Amanda said...

RE: Indexes

Hello Simon

Thank you for your question and welcome to the forum.

The Index function gives you the ability to ask Excel to extract a piece of data based on it's position within a range of cells - so similar to a v or hlookup except it isn't reliant on you having to specify a lookup value for it to find a piece of data in relation to.

The example provided in Excel Help is quite good, if you are interested in having a look at this, search for index function in Excel Help, and find the INDEX topic.

Kind regards
Amanda

Thu 9 Apr 2009: Automatically marked as resolved.

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips

Indexes

Indexes

RE: Indexes

Excel articles

Excel tip:

Edit and format multiple worksheets in one operation