Dear Friends,
Please like and subscribe my youtube channel so that I can come up with more videos.
Thank you
https://youtu.be/ajXVo6MM258
Please like and subscribe my youtube channel so that I can come up with more videos.
Thank you
https://youtu.be/ajXVo6MM258
YouTube
Paste Special option 'Column Widths' Hindi
Use of “Column Widths” option in Paste Special Command.
In continuation of last topic of “Paste Special”. Let us discuss Sixth Option “Column Widths”.
This will help in a situation where you want to make similar width of every column. Please use below steps:…
In continuation of last topic of “Paste Special”. Let us discuss Sixth Option “Column Widths”.
This will help in a situation where you want to make similar width of every column. Please use below steps:…
⭕️⭕️⭕️In continuation of topics going on, now we are coming with a new topic which is called “Lookup”.
This will help you in a situation where you want to find the data based on some lookup value. let us go through the syntax of ‘Lookup’: -
➡️➡️Syntax
=LOOKUP (lookup value, Array)
This will help you in a situation where you want to find the data based on some lookup value. let us go through the syntax of ‘Lookup’: -
➡️➡️Syntax
=LOOKUP (lookup value, Array)
☝️🟢Step 1: -
Click on Cell ‘H7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
Click on Cell ‘H7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
✌️🔵Step 2: - After Typing ‘Lookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
Dear Friends,
Please share this channel with your friends and family members. Please also like and subscribe my youtube channel so that I can come up with new videos of Excel.
Thank you
Please share this channel with your friends and family members. Please also like and subscribe my youtube channel so that I can come up with new videos of Excel.
Thank you
Please rate the content provided in the group, is it understandable to you.
Final Results
27%
1
18%
2
29%
3
12%
4
45%
5
M.S. Office, Excel, PowerPoint, Word pinned «⭕️⭕️⭕️In continuation of topics going on, now we are coming with a new topic which is called “Lookup”. This will help you in a situation where you want to find the data based on some lookup value. let us go through the syntax of ‘Lookup’: - ➡️➡️Syntax =LOOKUP…»
⭕️⭕️⭕️After discussion on “Lookup” first condition in which the lookup value is same as mentioned in the Table Array, let us discuss the second condition if the lookup value is different and not in the Table Array, then how lookup function will work.
➡️➡️SSyntax
=LOOKUP (lookup value, Array)
➡️➡️SSyntax
=LOOKUP (lookup value, Array)
☝️🟢Step 1: -
Click on Cell ‘K7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
Click on Cell ‘K7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
✌️🔵Step 2: - After Typing ‘Lookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
🤔🤔⭕️⭕️Question: -Why 0% is coming in front of 50 why not 5%?
🟢🟢Answer: - In the second condition, the sale value which we are trying to find is not available in the Table Array, we know that excel is very smart and, in this situation, excel will show you the discount of near lower value of that sale value.
♦️♦️Example,
➡️Sale value 50, Discount is 0% which is of 0 Sale Value.
➡️Sale value 150, Discount is 5% which is of 100 sale value
➡️Sale value 360, Discount is 15% which is of 300 sale value
➡️Sale value 985, Discount is 45% which is of 900 sale value
♦️♦️Example,
➡️Sale value 50, Discount is 0% which is of 0 Sale Value.
➡️Sale value 150, Discount is 5% which is of 100 sale value
➡️Sale value 360, Discount is 15% which is of 300 sale value
➡️Sale value 985, Discount is 45% which is of 900 sale value