↑ Return to Functions




  The INDEX function returns the contain of a cell at the intersection of a row and a column in a table or a reference. Contents1 Presentation of the function INDEX2 Function INDEX with 2 dimension3 Multi-Array4 Returns a reference Presentation of the function INDEX The INDEX function must have three parameters: References of a …

View page »


  The MATCH function converts¬†values into position inside a table (range of cells). Contents1 Presentation2 Examples in column3 Examples in row4 Use of the function with VLOOKUP Presentation MATCH function only needs two mandatory parameters and an optional parameter The researched value Reference data (a range of cell) with necessarily 1 dimension (a single row …

View page »

VLOOKUP (Approximate)

  This document will show you in which case you will use VLOOKUP function with the optional parameter = 1 (approaching). This sheet does not include explanations of construction of the function we have seen in “VLOOKUP (Exact Match)“. Contents1 Presentation of function VLOOKUP approximate2 Explanation3 Exercise Presentation of function VLOOKUP approximate Unlike using VLOOKUP …

View page »

VLOOKUP (Exact Match)

  Once you have a table with one or more columns, you can use VLOOKUP to returns one of the values in this table by referring to contents of first column. Contents1 Principle of the function VLOOKUP2 Remark3 Construction Principle of the function VLOOKUP Excel can be used as a database. Often, Excel files store …

View page »

Leave a Reply

%d bloggers like this: