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