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