Take This Quiz & Predict Your Score in the coming CA CS or CMA Exam!
  • How important it is for you to pass the exam in this attempt?
  • What percentage of course you have finished well so far roughly?
  • How many hours you study in a day?
  • How many times you have revised the topics you have finished
  • Have you taken online or pen drive or live class from a renowned faculty?
  • What percentage of the classes you have watched?
  • Have you attempted mock tests or practice tests yet?
  • Are you planning to attempt mock tests conducted by external bodies- ICAI, ICSI, ICMAI or other institute?
  • How many tests you have taken?
  • Did you manage to finish the test papers on time?
  • Are you strictly following study material provided by the exam conducting authority such as ICAI/ICSI/ICMAI/Other Body?
  • How is your health in general?
  • How is your food habit?
  • Any interest in yoga or exercise or play sports regularly?
  • Planning to sleep well nights before the exams?
  • Planning to have light food and water before exams?

Vlookup and Hlookup

Vlookup and Hlookup 

Image result for vlookup and hlookup

Microsoft Excel lookup is a Microsoft Excel function that searches for values in a column or row of a spreadsheet list or table. The V in VLOOKUP stands for vertical(column) while the H in HLOOKUP stands for horizontal (row).

Now A days For Every Professional Student it is very much necessary to know basic Excel concepts in which Vlookup and Hlookup are the most important ones

When performing a VLOOKUP, each match returns the corresponding value in the same row in the next column. For example, when looking up a number in a phone book, you read down the list of names until you find the name and then move your finger to the right to find the associated phone number.

A real world example of how a VLOOKUP could be used in Microsoft Excel is a spreadsheet containing a list of thousands of part numbers, each with their description and price. Using a VLOOKUP, you could type in the part number and immediately get the description or price of that part number.

Scroll Down and Download Vlookup and Hlookup with example for Reporting

Best Recommended Courses For CA CS CMA Professional 

Certificate in Business Management using Tally.ERP9 (Online)


Tally ERP 9 Video classes on the topic how to create single ledgers by Viral Jadhav

Certificate in Microsoft Excel for Business Professionals (Online)

Click here and Download Vlookup and Hlookup with example for Reporting

Vlookup and Hlookup with example for Reporting


Check out for Lot More Free Downloads at Visit books section

Also check out for Free Video lectures by Praveen Sharma by installing CAKART App

At CAKART you will get everything that you need to be successful in your CA CS CMA exam – India’s best faculty video classes (online or in pen drive) most popular books of best authors (ebooks hard copies) best scanners and all exam related information and

Leave a comment

Your email address will not be published. Required fields are marked *