Microsoft Office Tutorials and References

In Depth Information

**Looking It Up**

Here’s how to use the OFFSET function:

1. Click a cell where you want the result to appear.

2. Enter
=OFFSET(
to start the function.

3. Enter a cell address or click on a cell to get its address.

4. Enter a comma (
,).

5. Enter the number of rows you want to offset where the function looks

for a value.

This number can be a positive number, a negative number, or just 0 for

no offset.

6. Enter a comma (
,).

7. Enter the number of columns you want to offset where the function

looks for a value.

This can be a positive number, a negative number, or just 0 for no offset.

8. Type a
), and press Enter.

OFFSET is another of those functions that can be used alone but is usually

used as part of a more complex formula.

Looking It Up

Excel has a neat group of functions that let you extract data from lists and

tables. What is a table? A
table
is a dedicated matrix of rows and columns

that collectively form a cohesive group of data. Tables usually have labels

in the top row or the left column that identify the columns and rows of data.

The remainder of the table contains the data itself.

HLOOKUP and VLOOKUP

The HLOOKUP and VLOOKUP functions extract the data from a particular

cell in a table. HLOOKUP starts by searching across the first row of the table

to find a value that you specify. When it finds that value, it goes down the

column a specified number of rows and returns the value in the target cell.

VLOOKUP works the same way except that it searches down the first column

of the table and then moves across a specified number of columns.