Folusade has attended:
Excel Intermediate course
Excel Advanced course
Lookup table
How do I use a lookup table
RE: How to use Lookup
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