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.
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.