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