microsoft excel training london - 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