Excel Examples: IF, NOT, EXACT, & INDEX Functions

In this video tutorial we are going to use functions like IF, NOT, EXACT, INDEX to fulfil the requirement. Here the requirement is to fetch sales value wise to three product names. The product names will appear only at the first row of each DISEASE (Column C). EXACT function used to determine the first occurrence of a DISEASE. NOT function used to reverse the result which comes from EXACT function. It converts TRUE to FALSE and FALSE to TRUE. IF function used to identify the row for the top three item names. INDEX function fetching item names from column A. For top three positions range D2:F2 are used as reference. For more details watch the video.