(link)


Index:

=index(array, row number, column number)

Array should not include the row and column titles, just the values

Match:

=match(lookup value, column or row the value is in, 0)

Index Match:

=index(array, match(x,y,z), match(x,y,z))