Delta Fares

need help with this excel problem?

Set up cell B22 to display the destination that is the cheapest to travel to. Set up cell D22 to display the airline which will provide the cheapest fare to that destination. (cells produced below) A B C D 1 Airline Frankfurt Amsterdam London 2 United $571.73 $708.33 $896.13 3 Continental $599.48 $710.27 $846.63 4 Delta $608.22 $767.22 $904.17 5 Northwest $705.23 $1,871.27 $833.07 6 American $3,399.30 $5,344.65 $2,933.25

Public Comments

1. Assume your table above is in A1:D6, put this in B22 =INDEX(A1:D1,1, SUMPRODUCT((B2:D6=MIN(B2:D6)) *COLUMN(B2:D6))) put this in D22 =INDEX(A1:A6, SUMPRODUCT((B2:D6=MIN(B2:D6)) *ROW(B2:D6)),1) Please contact for more details