microsoft-excel-training - v lookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - V lookup

microsoft-excel-training - V lookup

resolvedResolved · Low Priority · Version Standard

Merline has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

V lookup

What is it?

RE: 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


Server loaded in 0.08 secs.