| Connect us with          
|now www.excelbasics.in is moved to www.basictutorials.in | Learn EXCEL,WORD,POWERPOINT,HTML Tutorials..Etc In Kannada |

HLOOKUP

Note:-Before starting any Formula or Function you need to add (=)

HLOOKUP is a Function which is used to retrieve the values from one row to another row correspondingly.it means it lookup the values horizontally. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.for good understanding you can watch below video & you can practice with downlodable sample sheet. below we provided downlodable sample sheet & video for your understanding.

Syntax:- HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

After watching video you can download below sample sheet. & it helps you to do practice more.please subscribe for more videos in our youtube channel.if you like our tutorial please share it on facebook & youtube below.
please leave your comments & suggestion in below form for better posts.




-