M.S. Office, Excel, PowerPoint, Word
@MSOfficeKnowledge
36K subscribers
143 photos
44 links
Knowledge Sharing
Download Telegram
About
Blog
Apps
Platform
Join
M.S. Office, Excel, PowerPoint, Word
36K subscribers
M.S. Office, Excel, PowerPoint, Word
Good News!!!!

In the coming days I will try to share content on Vlookup and then Hlookup.

Please do practice as much as you can and ask your doubts.

Thank You
22.4K views
M.S. Office, Excel, PowerPoint, Word
After having discussion on Lookup, let us now discuss one of the best function of Lookup Family ‘Vlookup’.

Syntax
= Vlookup (lookup_Value,table_array,col_index,[range_lookup])

Important Note: -
1. ‘V’ stands for Vertical lookup.
2. Only works towards extracting data from the Right side of the table.
24.5K views
M.S. Office, Excel, PowerPoint, Word
☝️🟢Step 1: - Click on Cell ‘J8’ and press ‘=’ this will activate the cell to use function, and start typing ‘Vlookup’.
23K views
M.S. Office, Excel, PowerPoint, Word
♦️♦️In the below screenshot you can see one problem is given with Table A and we need to find the Price in Table B. We will solve this problem with the help of ‘Vlookup’ function. Please follow below steps: -
21.9K views
M.S. Office, Excel, PowerPoint, Word
✌️🟢Step 2: - After Typing ‘Vlookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
21.5K views
M.S. Office, Excel, PowerPoint, Word
🤟🟣Step 3: - Select ‘Lookup Value in Cell I8’ as given in the syntax.
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
21.8K views
M.S. Office, Excel, PowerPoint, Word
✌️✌️🟢Step 4: - After selecting ‘Lookup Value in cell I8’, Select ‘Table Array from Cell D8 to E20’ from which you want to find the results of ‘lookup value’.
22.2K views
M.S. Office, Excel, PowerPoint, Word
🤟✌️🟣Step 5: - After selecting Table array please put koma (,) and the third field will reflect ‘Col_Index_Num’ which means from which column you want to find the results, Type number 2 here.

(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Price based on Product and Price is lying in second column that is why we typed 2 here)
23.9K views
M.S. Office, Excel, PowerPoint, Word
🤟🤟🟣Step 6: - After selecting ‘Col_Index_Num’ the fourth field will reflect ‘Range_lookup ‘ (1 for approximate match --> ‘True’ and 0 is for Exact Match --> ‘False’), will select 0 for exact match.
24.5K views
M.S. Office, Excel, PowerPoint, Word
🤟✌️✌️🟣Step 7: - After selecting 0, close the brackets ‘)’ and press ‘Enter’ or ‘Tab’.

You can see the yellow highlighted Cell J8 Price has come out of the Table A which is given in front of Bike Tyres.
25K views
M.S. Office, Excel, PowerPoint, Word
Dear Friends,
Please like and subscribe my youtube channel so that I can come up with Lookup and Vlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
27.5K views
M.S. Office, Excel, PowerPoint, Word
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
28.4K views
M.S. Office, Excel, PowerPoint, Word
M.S. Office, Excel, PowerPoint, Word pinned a photo
M.S. Office, Excel, PowerPoint, Word
After having discussion on Vlookup with Exact Match, let us now discuss Vlookup with Approximate Match.

Syntax
= Vlookup (lookup_Value,table_array,col_index,[range_lookup])

Important Note: -
1. ‘V’ stands for Vertical lookup.
2. Only works towards extracting data from the Right side of the table.
58K views
M.S. Office, Excel, PowerPoint, Word
♦️♦️In the below screenshot you can see one problem is given with Table A and we need to find the Price in Table B. We will solve this problem with the help of ‘Vlookup’ function. Please follow below steps: -
57.7K views
M.S. Office, Excel, PowerPoint, Word
☝️🟢Step 1: - Click on Cell ‘I9’ and press ‘=’ this will activate the cell to use function and start typing ‘Vlookup’.
55.6K views
M.S. Office, Excel, PowerPoint, Word
✌️🟢Step 2: - After Typing ‘Vlookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
57.2K views
M.S. Office, Excel, PowerPoint, Word
🤟🟣Step 3: - Select ‘Lookup Value in Cell H9’ as given in the syntax.
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
59.1K views
M.S. Office, Excel, PowerPoint, Word
✌️✌️🟢Step 4: - After selecting ‘Lookup Value in cell H9’, Select ‘Table Array from Cell D9 to E19’ from which you want to find the results of ‘lookup value’.
62.5K views
M.S. Office, Excel, PowerPoint, Word
🤟✌️🟣Step 5: - After selecting Table array please put coma (,) and the third field will reflect ‘Col_Index_Num’ which means from which column you want to find the results, Type number 2 here.

(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Discount Percentage based on Sale Value and Discount Percentage is lying in second column that is why we typed 2 here).
65.8K views
M.S. Office, Excel, PowerPoint, Word
🤟🤟🟣Step 6: - After selecting ‘Col_Index_Num’ the fourth field will reflect ‘Range_lookup ‘ (1 for approximate match --> ‘True’ and 0 is for Exact Match --> ‘False’), will select 1 for Approximate Match now.
68.3K views