Dear Friends,
Please like and subscribe my youtube channel so that I can come up with Lookup, Vlookup and Hlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Please like and subscribe my youtube channel so that I can come up with Lookup, Vlookup and Hlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Dear Friends,
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
Please rate the content posted in the group :-
Anonymous Poll
72%
1. Very Useful
30%
2. Useful
17%
3. Fine
Vlookup will help to find the value from :-
Anonymous Quiz
28%
Right to left
35%
Left to right
28%
Top to bottom
9%
Upper to lower
After having discussion on Lookup and Vlookup, let us now discuss one of the best function of Lookup Family ‘Hlookup’ with Approximate Match.
Syntax
=Hlookup(lookup_value, table_array, row_index_num, [range_lookup])
Important Note: -
1. ‘H’ stands for Horizontal lookup
2. Only works towards extracting data from the downside of the table.
Syntax
=Hlookup(lookup_value, table_array, row_index_num, [range_lookup])
Important Note: -
1. ‘H’ stands for Horizontal lookup
2. Only works towards extracting data from the downside of the table.
☝️🟢Step 1: - Click on Cell ‘C13’ and press ‘=’ this will activate the cell to use function, and start typing ‘Hlookup’.
🤟✌️🟣Step 5: - After selecting Table array please put koma (,) and the third field will reflect ‘Row_Index_Num’ means from which row you want to find the results, Type number 2 here.
(Explanation: - In this problem we have two rows in which data exist, and we want to find the Discount Percentage which is lying on 2nd row that is why we typed 2 here)
(Explanation: - In this problem we have two rows in which data exist, and we want to find the Discount Percentage which is lying on 2nd row that is why we typed 2 here)
🤟✌️✌️🟣Step 7: - After selecting 1, close the brackets ‘)’ and press ‘Enter’ or ‘Tab’.
You can see the yellow highlighted Cell C13 Discount Percentage has come out of the Table A which is given below of 0 (Zero) Sale Value. As you can see, we are searching for discount percentage of Sale value 50 but 50 is not given in Table A, As this is Approximate Match that is why if same sale value is not given then system will find the lower nearest results based on approximation. As you can see in below examples: -
1. In front of 50 the percentage is 0% which is of Sale Value 0.
2. In front of 133 the percentage is 5% which is of Sale Value 100.
3. In front of 345 the percentage is 15% which is of Sale Value 300.
But in below examples results are same as given in Table A: -
1. In front of 700 the percentage is 35% which is of Sale Value 700.
2. In front of 800 the percentage is 40% which is of Sale Value 800.
You can see the yellow highlighted Cell C13 Discount Percentage has come out of the Table A which is given below of 0 (Zero) Sale Value. As you can see, we are searching for discount percentage of Sale value 50 but 50 is not given in Table A, As this is Approximate Match that is why if same sale value is not given then system will find the lower nearest results based on approximation. As you can see in below examples: -
1. In front of 50 the percentage is 0% which is of Sale Value 0.
2. In front of 133 the percentage is 5% which is of Sale Value 100.
3. In front of 345 the percentage is 15% which is of Sale Value 300.
But in below examples results are same as given in Table A: -
1. In front of 700 the percentage is 35% which is of Sale Value 700.
2. In front of 800 the percentage is 40% which is of Sale Value 800.
Dear Friends,
Please like, subscribe and join my YouTube and telegram channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Please like, subscribe and join my YouTube and telegram channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Dear Friends,
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
Dear Friends,
I am doing my best to share the content on Excel in this group and requesting you all to please do more and more practice and ask your doubts in chat box.
Further I am also working on MS Word content as per demand from group members, shortly I will share the details.
Please do practice and like and subscribe the Telegram and YouTube Chennal.
Thank You
I am doing my best to share the content on Excel in this group and requesting you all to please do more and more practice and ask your doubts in chat box.
Further I am also working on MS Word content as per demand from group members, shortly I will share the details.
Please do practice and like and subscribe the Telegram and YouTube Chennal.
Thank You
Hlookup will help you to find the data from which side ?
Anonymous Quiz
40%
Left to Right
24%
Right to Left
29%
Top to Bottom
7%
Bottom to top
What should be a correct formula for sum in excel ?
Anonymous Quiz
67%
=Sum(B3:B9)
23%
=Sum(B3+B9)
7%
Sum(B3:B9)
3%
=Add(B3:B9)
Which Button allows you to copy cell formats from one cell to another?
Anonymous Quiz
17%
Enter
24%
Auto-fit
52%
Format Painter
7%
Esc
*Question of the day*
Question: - Which function we can use to find out the 2nd position from the bottom?
Options: -
Question: - Which function we can use to find out the 2nd position from the bottom?
Options: -
Anonymous Quiz
20%
Max
35%
Min
33%
Small
12%
Large