microsoft excel training london - Index function

Resolved · Low Priority · Version Standard

Wed 23 May 2007, 14:08 Delegate Annabel said...

Annabel has attended:
Excel Advanced course

Index function

What would you use Index & Match for?

Fri 25 May 2007, 12:42 Trainer Tracy said...

RE: Index function

Hi Annabel,

Thanks for the question

You can use the MATCH function to determine the relative position of a value in a range. The INDEX function on the other hand returns the cell value based on its relative position within a range. You can combine the two functions to get almost any piece of information from any table.

Tracy

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

microsoft excel training london - Index function

Index function

RE: Index function

Excel articles

Excel tip:

Convert a column into row quickly in Excel 2010