microsoft-excel-training - V lookup

Hi Merline,

Thanks for your question again. Hope you are feeling more confident in using Excel these days. Anyway, let's look at LOOKUP functions.

For example, a 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"

Hope this helps.

Katie