98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Index functions
Index functions
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:The Easiest Way to See a Sum or Average in Excel 2010Did you know the quickest and most simple way of working out the average or sum of a set of numbers? |