|
|
Search - Function INDEX
Page visited 11266 times
|
1. The INDEX function returns the value of the intersection of a table. The difference between the VLOOKUP function is the fact that you don't need to specify a value to search.
|
|
|
|
|
|
|
|
2. First, you just have to write the references of your table (without the title of the rows and the columns) ....
|
|
|
|
|
|
|
|
|
3. ... and you write which row number and column number you want.
Watch out here ! 4 means you focus on the forth row of your table ; the value 3 in the column title has no impact.
|
|
|
|
|
|
|
|
|
4. But in reality, it's better to use the contained of the headline to extract one figure of your table.
|
|
|
|
|
|
|
|
|
5. In this case, to find the value of the index in the function according to the value of the column A is not really difficult. You just have to add 1 the value of the cell and you obtain the index value.
|
|
|
|
|
|
|
|
|
6. On the other hand, you can't do the same for the columns because the value are not linear. So we must use another function to return the value of the location ; it's the MATCH function.
|
|
|
|
|
|
|
|
|
|
