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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
