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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Analytics Data Questions!