Hlookup Excel Example. Row index num required the row number in table array from which the value should be returned. Hlookup is a lookup function in excel and the hlookup formula is as follows.
Hlookup is one of those functions and this tutorial will show you how to use the hlookup function to lookup data within a table based on values you select. Base value or criterion value to search in the table. The hlookup function looks for a value in the first row of a table and returns a value from the same column in that table.
The marks of four subjects for five students are as follows.
It is a reference. Example 2 hlookup. Below in the first. Using the below table find the marks in english of a student who has.
