How to Use Vlookup in Excel Step by Step – Tutorial

How to Use Vlookup in Excel Step by Step – Tutorial. Vlookup in Excel 2007 Vlookup for Dummies Vlookup Between Sheets Vlookup in Excel Mac.

Vlookup in Excel – Step by Step Tutorial

The VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. It supports approximate and exact matching, and wildcards (*?) for partial matches. The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right.

एक्सेल में VLOOKUP

VLOOKUP तालिका में एक विशिष्ट स्तंभ से डेटा को देखने और पुनर्प्राप्त करने के लिए एक एक्सेल फ़ंक्शन है। VLOOKUP आंशिक मैचों के लिए अनुमानित और सटीक मिलान और वाइल्डकार्ड (*?) का समर्थन करता है। “V” का अर्थऊर्ध्वाधरहै। लुकअप मान तालिका के पहले कॉलम में, दाईं ओर लुकअप कॉलम के साथ दिखाई देना चाहिए।

How to Use Vlookup in Excel Step by Step

Main Functions of Vlookup

  • The VLOOKUP function searches for a specific value in your data, and once it identifies that value, it can find — and display — some other piece of information that’s associated with that value.
  • It is a Microsoft Tool; Microsoft Excel 2013 boasts a huge number of handy functions and utilities, many of which go unused by the average user. If you find yourself frequently needing to consult a table to find the same data, however, you’ll probably want to learn how to use VLOOKUP. Short for “vertical lookup,” VLOOKUP takes advantage of vertically-aligned tables to quickly find data associated with a value the user enters.
  • VLOOKUP only looks right
  • VLOOKUP always find the first match.
  • It is not Case-Sensitive
  • VLOOKUP uses approximate match by default
  • It can merge data in different tables
  • VLOOKUP can classify or categorize data
  • Absolute references make VLOOKUP more portable
  • Named ranges make VLOOKUP easier to read (and more portable)

How to Use Vlookup in Excel Step by Step

A unique identifier is a piece of information that both of your data sources share, and — as its name implies — it is unique (i.e. the identifier is only associated with one record in your database). Unique identifiers include product codes, stock keeping units (SKUs), and customer contacts

  • Click the cell where you want the VLOOKUP formula to be calculated.
  • Click “Formula” at the top of the screen.
  • Now Click “Lookup & Reference” on the Ribbon.
  • Click “VLOOKUP” at the bottom of the drop-down menu.
  • Specify the cell in which you will enter the value whose data you’re looking for. Set up VLOOKUP properly.
  • The data which you want VLOOKUP to use for its search in the table_array box.
  • Specify the column number which VLOOKUP will use to find the relevant data in the col_index_num box.
  • Somewhat confusingly, VLOOKUP requires you to use the numerical value of the column rather than its letter value.
  • Specify whether you need an exact match by entering either FALSE (exact match) or TRUE (approximate match) in the range_lookup box.
  • Click “OK” at the bottom of the popup window.
  • Enter the value whose data you’re searching for.

Purpose to Use Vlookup in Excel

  • In Excel the lookup command allows the user to set up a table of values and then using some other criteria search that table to return a specific value from it.
  • A VLOOKUP function is used to find correlated data. 
  • VLOOKUP & HLOOKUP have limitations so if you need to do this kind of lookup then learn INDEX & MATCH which work vertically
  • It’s an easy way to lookup a matching item and retrieves some data in columns.

Vlookup Syntax

  • VLOOKUP( value, table, index_number, [approximate_match] )

Arguments Used with Vlookup

  • Value – The value to look for in the first column of a table.
  • Table – The table from which to retrieve a value.
  • col_index – The column in the table from which to retrieve a value.
  • range_lookup – [optional] TRUE = approximate match (default). FALSE = exact match.

Add Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.