CA Final Download the best Free CA FINAL android app for cracking your exam! Download Now
They are the best ca final faculties in India. They have produced many toppers & rank holders. Their video classes are available only here -
CHECK VIDEO CLASSES HERE

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 cakart.in books section

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

At CAKART www.cakart.in 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 *