Skip to main content

Magic of V-Lookup

Magic of V-lookup:Magic of V-Lookup

Solution of following questions.

  • How to use vlookup? 

  • Working of Vlookup?

  • Introduction to vlookup?

As the name implies, V-Lookup, stands for Vertical Lookup, which is used to find specific information column wise vertically that has been stored in excel sheet.

Let’s study the Formula/Syntax of V-lookup function. It consists of four parts.

Lookup_value - This is the index which we have to search in the table.

Table_array, col_index_num - This is table array in which we search the look up value . This argument is a named range or a reference to a range of cells. Here, in above our table range is cell H2 to J7.

Col_index_num- Enter the column number of the table_array from which you want data returned from means which data you want to print as result. In above example, column index is 2 since value of name is 2nd position.

Range_lookup:  A logical value (TRUE 1 or FALSE 0 only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value.

    If TRUE(1) or if this argument is omitted, VLOOKUP will use an approximate match if it cannot find an exact match to the lookup_value. If an exact match is not found, VLOOKUP uses the next largest lookup_value.
    If FALSE(0), VLOOKUP will only use an exact match to the lookup_value. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, an #N/A error is returned.
Labels:

Comments

Post a Comment

Popular posts from this blog

Join the Beauty Course for Massage Beauty License Training

Massage Beauty School of California: Massage beauty program is one of the top ten beauty courses which are well recognized and sought after in the beauty sector. Several students from various cities and states enroll in this training program to get better learning opportunities and understand the minute technicalities of beauty massaging services. Certified schools and beauty institutes located in Los Angeles are offering cutting-edge training to the students who are eligible for the program. Palace Beauty College is an accredited beauty school that does offer a massage therapy program and also offers holistic learning facilities to the students. The college has years of experience in providing massage therapy license training in Los Angeles for more than half a decade now. The college maintains its official website to reach out to distant students and provide them relevant information related to the available beauty courses. The college takes pride in its impressive infrastru...
Post a Comment
Explore More »

Having issue with MDaemon Outlook Connector to connect MDaemon data with Outlook

Migration from MDaemon to Outlook is the right way to access MDaemon data in Outlook by using Outlook Connector Migration from MDaemon to Outlook Without Outlook Connector Migration from MDaemon to Outlook Overview: MDaemon Mail Server provides Outlook Connector for MDaemon which let you view and open MDaemon data with Outlook. Using Outlook Connector users will be able to view MDaemon Mail and contacts in Outlook. But if have you deleted any file from MDaemon then it will also missing from Outlook as well.   The way MDaemon Outlook Connector works is by keeping a locally cached copy file of the mail body in a database and the attach   files as a separate file. This is completely different from Microsoft Outlook Exchange caching where everything is kept in one OST file. The problem with this is it takes around 30 minutes to open Outlook (from a cold boot) which is quite unacceptable!! Sometimes users couldn’t able to send and receive email while using Ou...
Post a Comment
Explore More »

Most frequently asked interview question on String in java

 Here we describe difference between (==) and .equals() :- Both of them very much  differ  in their significance and working as equals() method is present in the java.lang.Object class and it is expected to check for the equivalence of the state of objects! That means, the contents of the objects. Whereas the '==' operator is expected to check the actual object instances are same or not. Let us see an example we have two String objects and they are being pointed by two different reference variables as a1 and a2. a1 = new String("xyz"); a2 = new String("xyz"); Now, if you use the "equals()" method to check for their equivalence as if(a1.equals(a2)) System.out.println("a1.equals(a2) is TRUE"); else System.out.println("a1.equals(a2) is FALSE"); You will get the output as TRUE as the 'equals()' method check for the content equivality. Lets check the '==' operator.. if(s...
Post a Comment
Explore More »