Are you looking for the price of a certain product from a large product range? Or are you looking for a certain birthday or the age of an employee in a staff table? In Excel you can search large sets of data selectively using VLOOKUP and get to the desired value in no time. In this Special Topic we will introduce the function VLOOKUP applying it in two examples, in order to show you when to search for an approximate match and when to search for an exact one.
To acces the videos for this Special Topic you must have subscribed to Excel !
Excel 2016
VLOOKUP Funktion:
We will show you in this video how to use the function VLOOKUP. With two examples we will explain the uses of approximate and exact searches. You can use the same procedure for the HLOOKUP function.
(8 Min.)
Excel 2013
VLOOKUP Funktion:
We will show you in this video how to use the function VLOOKUP. With two examples we will explain the uses of approximate and exact searches. You can use the same procedure for the HLOOKUP function.
(8 Min.)
Excel 2010
VLOOKUP Funktion:
We will show you in this video how to use the function VLOOKUP. With two examples we will explain the uses of approximate and exact searches. You can use the same procedure for the HLOOKUP function.
(8 Min.)
Excel 2007
VLOOKUP Funktion:
We will show you in this video how to use the function VLOOKUP. With two examples we will explain the uses of approximate and exact searches. You can use the same procedure for the HLOOKUP function.
(8 Min.)
Home
Special Topics
