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
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.