#HOW TO USE VLOOKUP IN EXCEL SAMPLE HOW TO#
#HOW TO USE VLOOKUP IN EXCEL SAMPLE CODE#

We can replace error #N/A with Р Р†Р вЂљРЎС™not foundР Р†Р вЂљРЎСљ. Suppose if you want to search the phone number of Р Р†Р вЂљРЎС™RajuР Р†Р вЂљРЎСљ but in the given list RajuР Р†Р вЂљРІвЂћСћs phone number is not there then VLOOKUP formula will show the error #N/AР вЂќР’В¬an use Р Р†Р вЂљРЎС™iferrorР Р†Р вЂљРЎСљ function to replace the error message with useful It will not show the result of the second name as highlighted in Р Р†Р вЂљРЎС™2Р Р†Р вЂљРЎСљ. Suppose if you want to search the phone number of Р Р†Р вЂљРЎС™NaliniР Р†Р вЂљРЎСљ then VLOOKUP function will search the first result only as highlighted in Р Р†Р вЂљРЎС™1Р Р†Р вЂљРЎСљ. Then VLOOKUP is an efficient tool or formula to perform the task Syntax will look like =VLOOKUP(F3,C2:D13,2,0)Р вЂќРЎС›: Indicates the column in which phone number is presentР вЂќР’В : Indicates the exact match Advantages of VLOOKUP :Р вЂќР вЂЎile with thousands of columns in it and you want to search for particular data Step4: Select the option between approximate match and exact match. In the given table name column is column no 1 and the phone number column is Table you have to specify the column number in which the phone number is there.

#HOW TO USE VLOOKUP IN EXCEL SAMPLE CODE#

In the given table you can see that theР вЂќР вЂЎirst column is Employee code but we have to select the table from name column i.e.

Select the table in such a way that the firstР вЂќР’В¬olumn should be the name of the person. Step2: Select the table in which we have to search Name of the person in F3 cell, therefore select the cell F3. Type the name of the person in an inverted comma for example: Р Р†Р вЂљРЎС™NaliniР Р†Р вЂљРЎСљ. Step1: Select the name of the person or you can also Use function or formula =VLOOKUP(F3,C2:D13,2,0)

#HOW TO USE VLOOKUP IN EXCEL SAMPLE HOW TO#

Here's how to integrate data from multiple sources with Microsoft Excel's VLOOKUP function. In this tutorial you will learn how you can. Also one of the formulas that are least used because so many users are scared of it. Example: Search the phone number of Р Р†Р вЂљРЎС™NaliniР Р†Р вЂљРЎСљ You might be trying too hard to organize your data in Excel. vlookup is one of the most powerful formula in Excel. Select the Р Р†Р вЂљРЎС™exact match option or put 0Р Р†Р вЂљРЎСљ. It not necessary that it should be theР вЂќР’В¬ol_index_num: In this, you have to mention the column in whichР вЂќР’В«etween approximate match and exact match. Should be on the right side of that column. Input data should be in the leftmost column and result data

Table_array: You have to select the table in which you have to Lookup_value: This function means, enter the data or select theР вЂќР’Вata for which you want to search the related data. This function scans the data in the left-most column and finds the result corresponding to the right of that cell. VLOOKUP formula or VLOOKUP function can reduce the work time by 80-90%. VLOOKUP formula is a very important tool and widely used in data analysis and day to day activities in office and businesses.

How to use vlookup in excel sample