वीलुकअप (VLOOKUP) एक एक्सेल कार्य है जो विशिष्ट मान को एक सूची में खोजने और प्राप्त करने में मदद करता है। “VLOOKUP” ऑफिस में उपयोग होने वाला एक महत्वपूर्ण एक्सेल फ़ंक्शन है जो विशिष्ट डेटा को खोजने और प्राप्त करने में मदद करता है। यह विशिष्ट मान को एक विशिष्ट सूची या तालिका में खोजकर …
Drop down in ms excel In Microsoft Excel, a drop-down list can be created using the “Data Validation” feature. Here’s how: Select the cell(s) where you want to create the drop-down list.Go to the “Data” tab in the ribbon menu.Click on “Data Validation” in the “Data Tools” group.In the “Data Validation” dialog box, select “List” …
Hi Friends ..This is our 2nd Tutorial of Basic Ms Excel where I use to upload video with live practice from basic level. So frequently we come across with the requirements of doing some basic customization in our any Excel bases report. Here under the Home tab there is Group “font” under that Bold,Italic,underline,Double Underline,Font …
Hi Friends, we frequently meet some data where we need to find out the smallest and largest value from the data. For example if we are having a data of cricket match and runs by the player and I have been asked to tell the 1st highest 2nd highest runs taken by the batsman. So …
As we all know Provident Fund is applicable for all those Industries having more than 20 employee is eligible for taking PF registration by Law.You all must having it as a part of your CTC or salary,here CTC stand for Cost to Company. The contribution which an organistaion deducted from salary need to be remit …
Excel Shorts on Vlookup
Conditional Formating in second. #Shorts -Protect your work book Ms Excel. 2.Most funniest Ms Excel Tips #Shorts 3. Drop Down in MS excel #Shorts 4.Here is the step by step vlookup with easy step 5. Date Reminder Popup Using Conditional Formatting date #Msexcel #exceltutorial #exceltips Add Smilies in Ms Excel Don’t Do This ! Auto Data Feedings #shorts Leadings …