Tag Archive: Research

Articles sur le thème : Research

Function MATCH

The MATCH function returns the position of a value in a range of cells This function is very useful to create dynamic research with the function VLOOKUP or INDEX. Presentation of the MATCH function MATCH function only needs two mandatory parameters and an optional parameter The researched value Reference data (a range of cell) with …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/function-match/

Vlookup to the left in Excel

Problem of the VLOOKUP function The normal behavior of the VLOOKUP function is to return data from a table. But you can only return data on the right of the column containing the ID. However, in some cases, you can not change the order of the columns. Like for instance in this document where the …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/vlookup-to-the-left-in-excel/