Vlookup And Hlookup Formula. We will insert the formula below into cell g5 vlookup g3 a5 e10 hlookup g4 b3 e4 2 false false we will press the enter key. Using the vlookup and hlookup functions.
Hlookup has almost the exact same syntax and structure as vlookup with the exception that the lookup is occurring horizontally and therefore you need a row index number instead of a column one. Here the formula vlookup h4 a2 e9 hlookup h5 b14 e15 2 false false lookup for the value toaster which is in cell h4 in the range a2. The vlookup and hlookup formula in excel is the two most important and widely used functions of excel.
Figure 3 result of the vlookup and hlookup functions.
In the function of vlookup the formula hlookup h5 b14 e15 2 false is given as the column index. So instead of defining column index with numbers you are doing this with the hlookup function. When the problems with memory are eliminated you can work with data using all of the same functions. As we will see this is why match is often used with index.
