Hlookup Function In Excel Example. You specify a column and a number and it returns the value of the cell in that column that many rows down. Next thing is we need to select the table array i e the main table.
Hlookup function in excel is a sibling of the vlookup function. It is a case insensitive lookup. It will consider for example tim and tim as the same.
The h in the hlookup stands for horizontal and hence it is often called horizontal lookup.
Open the hlookup formula in the salary column and select the lookup value as emp id. That might not seem that impressive. You specify a column and a number and it returns the value of the cell in that column that many rows down. It will consider for example tim and tim as the same.
