Vlookup

Resolved · High Priority · Version 2013

Wed 29 Jun 2016, 16:50 Delegate Matthew said...

Matthew has attended:
Excel Intermediate course

Vlookup

Please can you provide me with knowledge on how to create a vlookup

Thu 30 Jun 2016, 12:15 Trainer Marius said...

RE: Vlookup

Hi Matthew,

Thank you for your question. Please create the table below in cells A1:C11 of an Excel sheet.

ID Region Department
1 East Human resources
2 South Accounts
3 South Administration
4 South Marketing
5 East Customer support
6 West Human resources
7 East Accounts
8 North Administration
9 East Sales
10 North Sales

A Vlookup might be used to show which department someone works in if you provide the ID value.

In cell E1, enter 2. (the ID we want to locate)

In cell E2, enter the following Vlookup:
=VLOOKUP(E1,A2:C11,3,FALSE)

The result of this Vlookup will be Accounts

Explanation:

E1 is the cell which tells the Vlookup what to find in the first column of the selected table.

A2:C11 shows the Vlookup where the data table sits.

3 is the column in the table from which you want to show the result.

FALSE helps the Vlookup to find the correct item in the first column among unique and / or unsorted data.

I hope this helps.

Kind regards
Marius Barnard
STL

Thu 7 Jul 2016: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips