Entri Blog
No Result
View All Result
Thursday, March 30, 2023
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
    • Stock Market Course
      • Stock Market Course in Malayalam
      • Stock Market Course in Tamil
      • Options Trading Course
    • Spoken English Course
      • Spoken English Course in Malayalam
      • Spoken English Course in Hindi
      • Spoken English Course in Telugu
      • Spoken English Course in Tamil
      • Spoken English Course in Kannada
  • Others
    • GATE
    • MAT
    • KMAT
Try out Spoken English!
Entri Blog
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
    • Stock Market Course
      • Stock Market Course in Malayalam
      • Stock Market Course in Tamil
      • Options Trading Course
    • Spoken English Course
      • Spoken English Course in Malayalam
      • Spoken English Course in Hindi
      • Spoken English Course in Telugu
      • Spoken English Course in Tamil
      • Spoken English Course in Kannada
  • Others
    • GATE
    • MAT
    • KMAT
No Result
View All Result
Entri Blog
Spoken English
banner top article banner top article
Home Articles

How to Use VLOOKUP in Excel – Step by Step Guide

by Ramzeena Althaf
March 23, 2023
in Articles, Data Science and Machine Learning, Entri Skilling
how to use vlookup in Excel - step by step guide
Share on FacebookShare on WhatsAppShare on Telegram

Table of Contents

  • Usage of VLOOKUP
  • VLOOKUP Formula
  • How to use VLOOKUP in Excel?
  • Things to remember about the VLOOKUP Function

The VLOOKUP function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/ information. Vlookup (V stands for ‘Vertical’) is an in-built function in excel which allows establishing a relationship between different columns of excel.

Usage of VLOOKUP

We use VLOOKUP when we need to find some information in a large data-spreadsheet, or when we need to search for the same kind of information throughout the spreadsheet. This formula is often used in financial modeling and other types of financial analysis to make models more dynamic and incorporate multiple scenarios.

Experience the power of our Data Science course with a free demo – Enroll now!

VLOOKUP Formula

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number.

  1. Lookup_value (required argument) – The lookup value is the value for which you want to find matching data and must appear in the first column of the lookup table; it can be a value, a text string, or a cell reference.
  2. 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.
  3. Col_index_num (required argument) – This is an integer, specifying the number of columns Excel must count over to find the matching value.
  4. 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:
    • TRUE – If the range lookup argument is TRUE, or if a range lookup argument is not entered, VLOOKUP can find approximate matches. That is, if an exact match is not found, use the closest match below the lookup_value. In this case, the lookup table must be sorted in ascending order by the first column in it; otherwise VLOOKUP may not return the correct value.
    • FALSE – If the range lookup argument is FALSE, VLOOKUP will find only exact matches, that is, if an exact match is not found, then it will return an error.

How to use VLOOKUP in Excel?

Organize the data

The first step to effectively using the VLOOKUP function is to make sure your data is well organized and suitable for using the function. VLOOKUP works in a left to right order, so you need to ensure that the information you want to look up is to the left of the corresponding data you want to extract. If the tables are not in order, it will return an  error message. This is one of the major drawbacks of VLOOKUP,

Tell the function what to lookup

In this step, we tell Excel what to look for. Type the formula “=VLOOKUP(“ and then select the cell that contains the information we want to lookup).

Tell the function where to look

In this step, we select the table where the data is located, and tell Excel to search in the leftmost column for the information we selected in the previous step.

Tell Excel what column to output the data from

We need to tell Excel which column contains the data that we want to have as an output from the VLOOKUP.  To do this, Excel needs a number that corresponds to the column number in the table.

Exact or approximate match

This final step is to tell Excel if you’re looking for an exact or approximate match by entering “True” or “False” in the formula.

Let us have a look at an example:

  1. In the Formula Bar, type =VLOOKUP().
  2. In the parentheses, enter your lookup value, followed by a comma. This can be an actual value, or a blank cell that will hold a value: (H2,
  3. Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,
  4. Enter column index number. This is the column where you think the answers are, and it must be to the right of your lookup values: (H2,B3:F25,3,
  5. Enter the range lookup value, either TRUE or FALSE. TRUE finds partial matches, FALSE finds exact matches. Your finished formula looks something like this: =VLOOKUP(H2,B3:F25,3,FALSE)

Looking for a Data Science Career? Explore Here!

Things to remember about the VLOOKUP Function

  1. When range_lookup is omitted, the VLOOKUP function will allow a non-exact match. However it will use an exact match if one exists.
  2. If the lookup column contains duplicate values, VLOOKUP will match the first value only.
  3. The function is not case-sensitive.
  4. Suppose there’s an existing VLOOKUP formula in a worksheet. In such cases, formulas may break if we insert a column in the table. This is so because, when columns are inserted or deleted, hard-coded column index values don’t change automatically.
  5. VLOOKUP allows the use of wildcards, e.g., an asterisk (*) or a question mark (?).
  6. Suppose in the table we are working with the function contains numbers entered as text. If we are simply retrieving numbers as text from a column in a table, it doesn’t matter. But if the first column of the table contains numbers entered as text, we will get an #N/A! error if the lookup value is not also in text form.
  7. #N/A! error – Occurs if the VLOOKUP function fails to find a match to the supplied lookup_value.
  8. #REF! error – Occurs if either:
    • The col_index_num argument is greater than the number of columns in the supplied table_array; or
    • The formula attempted to reference cells that do not exist.
  9. #VALUE! error – Occurs if either:
    • The col_index_num argument is less than 1 or is not recognized as a numeric value; or
    • The range_lookup argument is not recognized as one of the logical values TRUE or FALSE.

Related Articles

Top 10 Advanced Excel Formulas Pivot Table in Excel – Introduction, Uses, Example
Top 100 Excel Interview Questions And Answers Keyboard Shortcuts in Excel for Data Entry
Microsoft Excel Malayalam Tutorial Basic Excel Formulas and Functions 
Share61SendShare
Ramzeena Althaf

Ramzeena Althaf

Ramzeena is a free thinker, an avid reader and tenacious when it comes to writing. An ardent Scrabble lover, she loves sharing exam updates and related topics for aspirants

Related Posts

Rajasthan SET Admit Card 2023 Out
Admit Card

Rajasthan SET Admit Card 2023 Out, Direct Download Link

March 23, 2023
What are Question Tags - Uses and Examples
Articles

What are Question Tags – Uses and Examples

March 23, 2023
Kerala PSC Dental Hygienist Grade-II Syllabus and Exam Pattern 2023
Articles

Kerala PSC Dental Hygienist Grade-II Syllabus and Exam Pattern 2023

March 22, 2023
Next Post
Kerala PSC Assistant Jailor Rank List

Kerala PSC Assistant Jailor Rank List 2023: Download PDF, Result Link

Discussion about this post

Latest Posts

  • Kerala State Co-operative Bank/Kerala Bank Recruitment Rules, 2023
  • TNTET Result 2023 for Paper II Out: Check at trb.tn.nic.in
  • FCI Assistant General Manager Recruitment 2023: Apply Online, Notification PDF
  • Best Career options after MCA – What to do After MCA?
  • Career Options after 12th Arts with High Salary in India

Trending Posts

  • states of india and their capitals and languages

    List of 28 States of India and their Capitals and Languages 2023 – PDF Download

    150261 shares
    Share 60102 Tweet 37564
  • List of Government Banks in India 2023: All you need to know

    61860 shares
    Share 24744 Tweet 15465
  • TNPSC Group 2 Posts and Salary Details 2022

    39693 shares
    Share 15877 Tweet 9923
  • KSDA Recruitment 2023 Apply Online for 9264 FDA SDA Posts – Qualification

    2076 shares
    Share 830 Tweet 519
  • New Map of India with States and Capitals 2023

    28793 shares
    Share 11517 Tweet 7198

Courses

  • Data Science Course
  • Full Stack Developer Course
  • Data Science Course in Malayalam
  • Full Stack Developer Course in Malayalam
  • Full Stack Developer Course in Hindi
  • Full Stack Developer Course in Tamil
  • Full Stack Developer Course in Telugu
  • Full Stack Developer Course in Kannada

Company

  • Become a teacher
  • Login to Entri Web

Quick Links

  • Articles
  • Videos
  • Entri Daily Quiz Practice
  • Current Affairs & GK
  • News Capsule – eBook
  • Preparation Tips
  • Kerala PSC Gold
  • Entri Skilling

Popular Exam

  • IBPS Exam
  • SBI Exam
  • Railway RRB Exam
  • Kerala PSC
  • Tamil Nadu PSC
  • Telangana PSC
  • Andhra Pradesh PSC
  • MPPSC
  • UPPSC
  • Karnataka PSC
  • Staff Selection Commission Exam

© 2021 Entri.app - Privacy Policy | Terms of Service

No Result
View All Result
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
    • Stock Market Course
      • Stock Market Course in Malayalam
      • Stock Market Course in Tamil
      • Options Trading Course
    • Spoken English Course
      • Spoken English Course in Malayalam
      • Spoken English Course in Hindi
      • Spoken English Course in Telugu
      • Spoken English Course in Tamil
      • Spoken English Course in Kannada
  • Others
    • GATE
    • MAT
    • KMAT

© 2021 Entri.app - Privacy Policy | Terms of Service