• 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 Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at dptutorials15@gmail.com

Support my blog, if you liked

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Google+ Social Icon
  • Blogger Social Icon