Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between each

Question:

Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between each pair of cities in the Excel file General Appliance Corporation. Your table should display as follows, and the formula for the amount should reference the names in the From and To columns:

From To Amount Marietta Cleveland 0 Marietta Baltimore 350 Marietta Chicago 0 Marietta Phoenix 850 Minneapolis Cleveland 150 Minneapolis Baltimore 0 Minneapolis Chicago 500 Minneapolis Phoenix 150

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics

ISBN: 9781292095448

2nd Global Edition

Authors: James R. Evans

Question Posted: