Excel Tutorial Vlookup And Hlookup

Learning how to do a hlookup in excel is the same as a vlookup the data is instead looked up horizontally rather than vertically.

Excel tutorial vlookup and hlookup. The hlookup and vlookup functions are the same in function and syntax except for the vertical and horizontal differences. In this formula the horizontal value 2016 is looked up with the hlookup section of the formula. This function retrieves data from the table horizontally. In the last of this video you learn how to use vlookup and hlookup in microsoft excel.

The hlookup function is the not as cool younger sibling of vlookup. Excel has a range of functions that you can use to achieve this including vlookup and hlookup and the more flexible but slightly more complicated combination of index and match. Figure 3 result of the vlookup and hlookup functions. While using index match for vertical lookups and index match match for matrix style lookups are superior approaches its still a good idea to learn this formula combination and add it to your toolkit of lookup approaches.

Hlookup works similarly to the vlookup function. Vlookup and hlookup are two of the most popular formulas in excel and using them together is one of the first formula combinations that people learn. And its uses in very easy methodhttpsyoutubecha3dqu3ito. Hlookup function has the following form.

There is a lookup but this is only hangs around as its compatible with old versions of excel. It is globally accepted that vlookup is one of the handiest functions available in excel. Despite it i think its worth it to know hlookup. The hlookup function searches for a value in the top row of a table or an array of values and then returns a value in the same column from a row you specify in the table or array.

Although the excel lookup functions can seem quite straightforward its very easy to get the wrong answer if you dont fully understand how they work. For more details and step by step tutorials on how to use this function and other advanced excel functions sign up for the microsoft excel advanced excel 2010 training course from udemy and learn to harness the power of functions in your worksheets. Vlookup and hlookup are part of some of the more advanced functions available in excel. The returned value by hlookup is 5 because hlookup searches for 2016 in the range b3e4 in row 2.

Most of the tables in excel create a vertical so this feature is rarely used. Hlookup is a lookup and reference function.