Techshristi's Forum

Author Topic: V lookup Excel Tutorial  (Read 866 times)

0 Members and 1 Guest are viewing this topic.

Offline TechShristi

  • Welclome to Techshristi
  • Administrator
  • *****
  • Posts: 556
    • techshristi
V lookup Excel Tutorial
« on: December 18, 2016, 03:14:59 PM »
What is V look Up?
V Look up is used when we want to pull out the particular value from the table provided that there is one common factor/value. For example: In attached tutorial, we have the roll number and name of the students as common factor and we want to pull the marks received by the students from table 1.



We will pull the marks obtained by the individual students in next table.

Steps
a) Type the V Look up formula in the column where you want to pull the value or marks. Here in this attached tutorial or files, we will type the formula in column c of the work sheet 2 table.



b) Once you typed the v look up, a small pop up will start appearing below the formula. Here

lookup_value means the value that is common in both table. Here Roll Number and Name is common in both table. We will pull out the data using roll number
table_array mean the table from where you want to pull the data. Here we will use the table 1 from worksheet 1
col_index_number mean that column from where you want to pull the amount provided common factor matches.

Here in this tutorial, column number will be three. Since the marks obtained appear in third column starting from the common value that is roll number. It will also appear at the time of selecting the table array as shown below



c) Once you completed with the formula press enter to get the value. Then copy the formula and paste the same where you want to appear the value.


Do not forget to add 0 at the end of the formula for getting exact result. Zero stand for exact and One stand for appropriate match.

Formula will look like this
Press F4 if dollar sign appear before or after the table array.Dollar sign is used for absolute and relative value reference. We will discuss about this in next tutorial





[smg id=128 type=av]
« Last Edit: December 18, 2016, 03:19:53 PM by TechShristi »

Techshristi's Forum

V lookup Excel Tutorial
« on: December 18, 2016, 03:14:59 PM »

Offline TechShristi

  • Welclome to Techshristi
  • Administrator
  • *****
  • Posts: 556
    • techshristi
Re: V lookup Excel Tutorial
« Reply #1 on: December 18, 2016, 03:24:52 PM »
Short Cut Method for doing the V Look Up

a) Click on Function option given the start of function bar in excel.
b) Once you click on the function bar a window will appear will different options as shown below


Fill the respective data and click Ok for the result. Meaning of all feild is already explained in below tutorial. Please refer complete article for the meaning of the table array, vlookup value etc

Techshristi's Forum

Re: V lookup Excel Tutorial
« Reply #1 on: December 18, 2016, 03:24:52 PM »

 
Sitemap 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18