Vlookup Hlookup In Excel Tutorial

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 hlookup in excel tutorial. Vlookup and hlookup are part of some of the more advanced functions available in excel. Learn how to use vlookup and hlookup together in excel we can use a nested formula that combines the vlookup and hlookup functions in excel to retrieve values from a table. The steps below will walk through the process. 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.

Its just like a vlookup except that it performs lookups horizontally rather than vertically. Hlookup tutorial want to perform a vlookup but not sure how to do so on a horizontal table. The hlookup and vlookup functions are the same in function and syntax except for the vertical and horizontal differences. It is globally accepted that vlookup is one of the handiest functions available in excel.