excel training microsoft - Lookup table

Hi Folusade,

Thanks for your question.

There are 2 lookup functions: VLOOKUP & HLOOKUP. Depending on whether your data list is lined up Vertically (VLOOKUP) or Horizontally (HLOOKUP).

Both are used to find a record from a large table.

For example, a 3-column table range from "A8" to "C20" stores Employee Info across column A to C with headings:
Employee No, Dept & Salary.

You can find info on a particular employee, using VLOOKUP.

=VLOOKUP (search cell address, data table range, result column number, match type)

In a sample scenario:
Set cell "A6" as search cell with employee no "E012"
Set data table between "A8 to C20"
Lookup the salary of employee No. "E012" - 3rd column of the data table
Matching exact Employee No.

The function will be as follows:
=VLOOKUP ("A6", "A8:C20", 3, false)

The answer will return the salary figure of employee "E012"

Regards,

Katie