Microsoft Office Tutorials and References

In Depth Information

**Looking It Up**

This returns a range that has the following characteristics:

✓
Offset by no rows and three columns from the Sales range

✓
Has a height equal to the number of rows in Sales

✓
Has a width of one column

Now that you have this range, you can tell MATCH to look for the largest value

that is less than or equal to 10000. Because the data is sorted, the relative

position of this value in the range is one more than the number of products

with sales less than $10,000. Why one more? Because the heading row at the

top of the range is counted too — so you subtract 1 to get the final answer.

Figure 14-12:

Making a

match.

Here’s how to use the MATCH function:

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

2. Enter
=MATCH(
to start the function.

3. Enter a value to match.

This can be a numeric, text, or logic value. You can enter a cell address

provided the referenced cell has a usable value.

4. Enter a comma (
,).