answerOn the World Capital Cities worksheet, click cell G2.In the Formula Bar just below the ribbon, type =MATCH, and then press Tab on your keyboard to begin entering the function arguments.
To the left of the Formula Bar, click fx to open the Function Arguments pop-up wizard.
In the Function Arguments wizard, enter the following:
Lookup_value: F2
Lookup_array: $B$2:$B$198
Match_type: 0
Click OK.
Select the formula in the Formula Bar and cut it. (Hint: You can cut it by using the Cut command on the Home tab, by right-clicking and selectingCut, or by using the keyboard shortcut Ctrl+X.)In the Formula Bar, enter =INDEX, and then press Tab on your keyboard to begin entering the function arguments.
To the left of the Formula Bar, click fx to open the Function Arguments pop-up wizard.
In the Select Arguments pop-up window, select array, row_num, and col_num,and then click OK.
In the Function Arguments wizard, enter the following:
Array: $C$2:$C$198
Row_num: MATCH(F2,$B$2:$B$198,0)
Col_num: leave this field blank
Click OK. (Hint: The result displayed in cell G2 should be 2,206,300, and the final formula should read=INDEX($C$2:$C$198,MATCH(F2,$B$2:$B$198,0)).)