Microsoft Excel Functions & Formulas

Use the INDEX function to search for data

in a sorted list

In addition to VLOOKUP, the INDEX function can be used to

search for data in a sorted list. Copy the table below to a new

worksheet and enter in cell A2 the team number for which you

want to search. Let Excel search for the team name and corre-

sponding costs with the INDEX or VLOOKUP functions as

described in the next steps.

4

To search for data in a list:

1. In cell A2 enter a valid number from 1 to 7.

2. Select cell B2 and type the following formula:

=INDEX($A$6:$C$12,MATCH($A$2,$A$6:$A$12,0),2).

3. In cell B3 type the following formula:

=VLOOKUP($A$2,$A$5:$C$12,2,FALSE).

4. Select cell C2 and type ...