Learn "Microsoft Excel" [through Blog of DPAB]

Hello Friends, In this Post, you can compare and understand about VLOOKUP and HLOOKUP.   More update to come in this post itself. Please wait. You will get free template to download and practice too. Thanks and Regards, Prabhakar Download File and Refer only sheet named as "TA Master" (File Name "Chapter-VLOOKUP.xlsx") ⬇

    Hello Friends, In Excel VLOOKUP - is a Built-in Function (Not a User Defined Function]. Almost 90+% of Excel Expert in the world knows the benefits of it, when handling large amount of Data. Beginners perhaps once learned VLOOKUP, want to practice it, but find no time to build data for it. Here you can find free to Download VLOOKUP Practice Template. I am Prabhakar, spent Quality time to build this VLOOKUP Practice Template, which is very easy to understand and Practice. Guidelines on How to Practice VLOOKUP A. Warning Use "Microsoft Edge" as the Browser and not "Google Chrome", because sometime, it happened so that, Excel File is converted as Google Sheets. This removes the important setting in Excel and the file may not perform as per its original design. B. To Practice Case (i) When "table_array" is in same sheet and Case (ii) When "table_array" is in another sheet [Step 1] Download the File named as " V...

  Hello Friends This Blog Post Provides Direct Downloadable link to Download Excel Template to Practice, when the Table Array is in Same Sheet of the VLOOKUP Fomula's cell Download "VLOOKUP Template - FMCG DSR - 001" 📥 Download "VLOOKUP Template - FMCG DSR - 001   Please share your Gratitude and Any Other Feedback in comment section. Thanks and Regards, Prabhakar Srinivasagam 11_hgoJiw8Urpn2xb8_PcG2Kpy7Y4pNNB https://drive.google.com/file/d/1a5OKaefEclNB7eo6NkJkzTH4situlQ1-/view?usp=drive_link

  Hello Friends, Welcome to my Blog Post, on XLOOKUP Practice Template - 001. I am Prabhakar, the Author of this Post as well as Author of the YouTube Channel "DPAB".     If you are unable to use VLOOKUP and HLOOKUP in your Data, then the right choice is XLOOKUP, which works irrespective of the position of the column in which the "lookup_value" is available, Why XLOOKUP instead of VLOOKUP?     CONDITION to go for VLOOKUP :    In VLOOKUP the column having the "lookup_value" should be in the left most of the "table_array" you select; that is it should be the first column and the column having the required answer data should be in the right side of it. If this condition is failed, XLOOKUP is the best choice. In fact XLOOKUP can be used instead of VLOOKUP whether above Condition is met or not. Why XLOOKUP instead of HLOOKUP?      CONDITION to go for HLOOKUP:   In HLOOKUP the Row having the "lookup_value" should be the top most row ...

  Hello Friends,                Welcome to this Post "VLOOKUP Practice Template-001". [Post Ref: Post-002-6Oct2025]. This is from the Blog of "Learn Microsoft Excel - By DPAB Prabhakar. Download at Free of Cost: (Link at bottom of this page) Download, Practice and share your Gratitude in Comments But Payments are accepted as Gift, as explained below If you want to support by sending payment, first, please Download, Practice. Only after practice decide for payment. Because the Author [who is also Author of the YouTube Channel "DPAB"], want your satisfaction first. Only after your satisfaction, and if you decided to send payment, then you can send any amount, in INR only. Say Rs1 or Rs9 or Rs99 etc or any amount. To get the payment Link, send your contact details to j16263dp@rediffmail.com, as explained below. Warning: To Download, use " Microsoft Edge" as your Browse...