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.
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 ( ,).