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

excel training microsoft - lookup table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Lookup table

excel training microsoft - Lookup table

ResolvedVersion Standard

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

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.