☝️🟢Step 1: - Click on Cell ‘J8’ and press ‘=’ this will activate the cell to use function, and start typing ‘Vlookup’.
🤟✌️🟣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)
(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)
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
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
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
☝️🟢Step 1: - Click on Cell ‘I9’ and press ‘=’ this will activate the cell to use function and start typing ‘Vlookup’.
🤟✌️🟣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).
(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).
🤟✌️✌️🟣Step 7: - After selecting 1, close the brackets ‘)’ and press ‘Enter’ or ‘Tab’.
You can see the yellow highlighted Cell I9 Discount Percentage has come out of the Table A which is given in front of 100. but other results are not matching, because this is Approximate Match, and the system will find the lower nearest results based on approximation. As you can see in below examples: -
1. In front of 250 the percentage is 10% which is of 200.
2. In front of 650 the percentage is 30% which is of 600.
You can see the yellow highlighted Cell I9 Discount Percentage has come out of the Table A which is given in front of 100. but other results are not matching, because this is Approximate Match, and the system will find the lower nearest results based on approximation. As you can see in below examples: -
1. In front of 250 the percentage is 10% which is of 200.
2. In front of 650 the percentage is 30% which is of 600.
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
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