VLOOKUP function

Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number.

In its simplest form, the VLOOKUP function says:

=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact match or Approximate Match- indicated as 0/FALSE or 1/TRUE).


Follow below steps for exercise
Step 1

Sheet 1 contains First , Last & Pcode details are there , we need to find out Name of the Pcode

Step 2

Sheet 2 contains Pcode ( Party code ) & Name

Step 3

Add Another column in Sheet 1 next to Pcode column, then slect D2 row

Step 4

Press Function Key F2 or go through below steps.

Click insert function under Formulas,
Select Category as ALL
Search of function  type VLOOKUP
clck on Go Button.

Step 5

select columns as  per the below screen

Step 6

Click on OK button, then you will get appropriate data against Pcode.
you can copy and past formula  to other rows