Excel Tips : How to use VLOOKUP function in Excel ?


What is VLOOKUP in simple words?

When you need to extract data from a table based on a particular value, you can use VLOOKUP to do that. In simple terms, it looks at a table in the first column for a specific value and returns a cell in the same row where you choose the column to return from.

The VLOOKUP function uses the following arguments:

a.          Lookup_value (required argument) – Lookup_value specifies the value that we want to look up in the first column of a table.

b.    Table_array (required argument) – The table array is the data array that is to be searched. The VLOOKUP function searches in the left-most column of this array.

c.         Col_index_num (required argument) – This is an integer, specifying the column number of the supplied table_array, that you want to return a value from.

d.     Range_lookup (optional argument) – This defines what this function should return in the event that it does not find an exact match to the lookup_value. The argument can be set to TRUE or FALSE, which means:

i.             TRUE – Approximate match, that is, if an exact match is not found, use the closest match below the lookup_value.

ii.                 FALSE – Exact match, that is, if an exact match not found, then it will return an error.



Please go through the below link for complete demonstration for using VLookup Function :






Blogger Name: Pramod Kumar Kushwaha
For more information & feedback write email at : pktipsonline@gmail.com

इस ब्लॉग से लोकप्रिय पोस्ट

कश्मीर : धरती का स्वर्ग (Trip to Kashmir : Paradise on Earth - Hindi Blog)

मालवण : सिंधुदुर्ग की शान ( Trip to Malvan - Hindi Blog )

महाबलेश्वर और पंचगनी : एक प्यारा सा हिल स्टेशन (Trip to Mahabaleshwar & Panchgani - Hindi Blog)

श्रीनगर : एक खूबसूरत शाम डल झील के नाम (A Memorable Evening in Dal Lake Srinagar - Hindi Blog)

समुद्र में मोती : अंडमान निकोबार द्वीप समूह की यात्रा (Andaman Trip - Hindi Blog)

चित्रकूट : जहाँ कण कण में बसे हैं श्रीराम (Trip to Chitrakoot - Hindi Blog)

पालखी : पंढरपुर की धार्मिक यात्रा(Palkhi Yatra to Pandharpur - Hindi Blog)

प्राचीन गुफाओं और मंदिरों का शहर : बादामी, पट्टदकल और ऐहोले (Trip to Badami, Pattadkal & Aihole - Hindi Blog)

कास पठार : महाराष्ट्र में फूलों की घाटी (Trip to Kaas Plateau : Maharashta's Valley of Flower-Hindi Blog)

ऊटी और कुन्नूर : नीलगिरी का स्वर्ग (Trip to Ooty & Coonoor - Hindi Blog)