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 »

Former President APJ Abdul Kalam Died at 83

"Missile Man is no more" A.P.J Abdul Kalam died in Shillong. He was brought into the hospital without a pulse or BP. There was no sign of life John Sailo Ryntathiang, director of Bethany Hospital," told the Quint. About Abdul Kalam: Abdul Kalam was an Indian scientist who was the 11th President of India from 2002 to 2007. Kalam was born and raised in Rameswaram(Tamil Nadu) and studied physics and aerospace engineering. He worked as a scientist and science administrator, mainly at the Defence Research and Development Organisation (DRDO) and Indian Space Research Organisation (ISRO) before he became president. The Centre has declared national mourning for seven days. Kalam served as president for five years from 2002, enjoying the support of both the ruling BJP and the opposition Congress. He graduated from Saint Joseph's College, Tiruchirappalli in 1954 but not satisfied with his degree, he left for Madras later next year to study aerospace engineering. He enrolled ...
Post a Comment
Explore More »

Cryptocurrency: The future currency and bitcoin investment

What is Cryptocurrency? Cryptocurrency is a digital or virtual currency that uses cryptography for security. A cryptocurrency is a medium of exchange that uses cryptography to secure transactions and control the creation of additional units. Cryptocurrency uses a decentralized system of records called a blockchain to track transactions instead of using a traditional database like a conventional currency. The crypto world is full of surprises. New coins and tokens are being launched almost every day. Some of these go on to change the world, while others will fizzle out and be forgotten. It’s impossible to predict which ones will thrive and which ones will fail, but crypto is a great way to keep up with the latest developments in technology and finance. Cryptocurrency is a digital or virtual currency that uses cryptography for security. A cryptocurrency is difficult to counterfeit because of this security feature. A defining feature of a cryptocurrency, and arguably its most alluring ass...
Post a Comment
Explore More »