Ashvi City - Mr. Excel

VLOOKUP Function: Summary VLOOKUP is one of the most powerful tools in Excel. The VLOOKUP function enables you to look up data corresponding with the row of a lookup value and corresponding column index. It sounds like a very simple thing, and it is. For example, the VLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table. You can create a simple Excel table that uses VLOOKUP to lookup and present data from one or other tables.   Don’t worry if it’s sound little difficult, by the end of this article, you will be able to teach others about the VLOOKUP.   First will let you know about the purpose and syntax of the same.   Purpose The VLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table.   Arguments & Syntax   As Syntax given above VLOOKUP  contain 4 different arguments, the ...

Excel IF Function   Summary The IF function can perform a logical test and return one value subject to TRUE and FALSE value placed by you. IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and whatever you want. For example, to avail incentive, branch should do more than 5 crores sell in a month:  =IF(B2>5,"Eligible","Not Eligible") So, IF function provided two results. First for your TRUE comparison and Second for FALSE comparison as an example given above. Open this video to understand IF function with different data: Above Youtube video link:   https://www.youtube.com/watch?v=CQzsydfB_EE   Purpose IF is a conditional function, who helps us to find out a result on the basis of conditions entered by you.   Translation =IF(B2>5,"Eligibile","Not Eligible") If in the above formula value in “B2” is greater than 5, the return value is Eligible. Otherwi...