q 13

The graphic below includes a depiction of a list of the baseball stadiums in the American Baseball League. The numbers in the inner part of the table represent the number of miles between the column city and the row city. For instance, cell J5 holds the number of miles between the stadium in Chicago (CHI) and the stadium in Seattle (SEA). We want cell C23 to hold the number of miles between Seattle (SEA) and Oakland (OAK). What formula would give you the correct answer?

A B C D E F G 1 American Baseball League Intercity Distances H I J K L M N O P Q R S 4 Data 0 1 2 3 4 5 6 7 8 9 10 11 12 13 SEA OAK CAL TEX KC MIN CHI MIL DET CLE TOR BAL NY BOS SEA O 678 954 1670 1489 1399 1720 1694 1932 2023 2124 2334 2421 2469 OAK 678 0 337 1467 1498 1589 1846 1845 2079 2161 2286 2457 2586 2704 CAL 954 337 0 1246 1363 1536 1745 1756 1979 2053 2175 2329 2475 2611 TEX 1670 1467 1246 0 460 853 798 843 982 1015 1186 1209 1383 1555 KC 1489 1498 1363 4600 394 403 483 630 694 822 961 1113 1254 MIN 1399 1589 1536 853 394 0 334 297 528 622 780 936 1028 1124 CHI 1720 1846 1745 798 403 334 0 74 235 307 430 621 740 867 MIL 1694 1845 1756 843 483 297 74 0237 328 434 641 746 860 DET 1932 2079 1979 982 630 528 235 237 0 95 206 409 509 632 CLE 2023 2161 2053 1015 694 622 307 328 950 193 314 425 563 TOR 2124 2286 2175 1186 822 780 430 434 206 193 0 384 366 463 BAL 2334 2457 2329 1209 961 936 621 641 409 314 384 0 184 370 NY 2421 2586 2475 1383 1113 1028 740 746 509 425 366 1840 187 BOS 2469 2704 2611 1555 1254 1124 867 860 632 563 463 370 1870 12 13 20 Model 21 22 From To Distance 678 337 1246 460 394 334 74 No 00 AWN From To SEA OAK OAK CAL CAL TEX TEX KC KC MIN MIN CHI CHI MIL MIL DET DET CLE CLE TOR TORBAL BAL NY NYBOS BOS SEA 95 193 384 184 187 2469 7272 13 0 Total O=INDEX($D$5:$Q$18,A23+1,B23+1) O =MATCH($D$5:$Q$18,A23+1,B23+1) O All of the solutions work. 0 =VLOOKUP($D$5:$Q$18,A23+1,B23+1)