As promised in Thursday's post on an introduction in the VLOOKUP function, we will today have a look on a change of the last parameter of the VLOOKUP function: The Range lookup. In the previous post we entered the value FALSE which told MSXL that we are searching for an exact match of the ID we used as identifier (read the introduction in the VLOOKUP function for further details).

Today I want to give you an introduction into the mysterious VLOOKUP function of MSXL (woohooo, spooky!!). This is the first article in a series on posts on the lookup functions of MS Excel. Those come in very handy and are actually very powerful, as they give you possibilities which otherwise would have needed VBA.