index functions

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Index functions

Index functions

resolvedResolved · Low Priority · Version 2007

Stephen has attended:
Excel Advanced course

Index functions

Under what circumsatnces might it be better to use the index function rather than vlookups?

RE: Index functions

Hi Stephen

A VLOOKUP function searches for value in the left-most column of a table array and returns the value in the same row based on the index number of the column.

The syntax for the VLookup function is:

VLookup( value, table_array, index_number, not_exact_match )

In contrast a INDEX function returns an item from a specific position in a list.

The syntax for the Index function is:

Index(array, row_num, [column_num])

The Index function is used when you know the position of the information required (Row 23, Column 10).

Hope this helps

Carlos

Thu 27 Nov 2008: Automatically marked as resolved.


 

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.09 secs.