• Dp

"HLOOKUP" Function In Excel

Updated: Jun 24, 2018

This function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down the column to pick a cell entry.


Syntax:

=HLOOKUP(ItemToFind,RangeToLookIn,RowToPickFrom,SortedOrUnsorted)


The ItemToFind is a single item specified by the user.

The RangeToLookIn is the range of data with the column headings at the top.

The RowToPickFrom is how far down the column the function should look to pick from.

The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes, FALSE for no.


Example:



Video Tutorial:

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and </