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
M.S. Office, Excel, PowerPoint, Word pinned «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…»
Dear Friends,
Good News!
After having discussion on Lookup and Vlookup now it's time for Hlookup.
I know that you all are very excited for this. Please write in comments.
I will share the detailed step wise notes shortly.
If you have any doubt related with Lookup and Vlookup you can ask.
Thank you
Good News!
After having discussion on Lookup and Vlookup now it's time for Hlookup.
I know that you all are very excited for this. Please write in comments.
I will share the detailed step wise notes shortly.
If you have any doubt related with Lookup and Vlookup you can ask.
Thank you
After having discussion on Lookup and Vlookup, let us now discuss one of the best function of Lookup Family ‘Hlookup’.
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 ‘H10’ 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 3 here.
(Explanation: - In this problem we have seven rows in which data is exist, and we want to find the Sale of May month which is lying on 3rd row that is why we typed 3 here)
(Explanation: - In this problem we have seven rows in which data is exist, and we want to find the Sale of May month which is lying on 3rd row that is why we typed 3 here)
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’.