7 105 Now that Kareem understands how to use the VLOOKUP function, he tries to write a formula to return the carrier code given the airline name. Surprisingly, he gets the #N/A! error. What could be the source of the error? B8 fx =VLOOKUP(A8,A2:C5,1,FALSE) A B D E 1 Carrier 2 JB 3 DL 4 LH AC 6 7 Airline 8 Delta Airline JetBlue Delta Lufthansa AirCanada Country US US GER CAN Carrier #N/A The range_lookup should be TRUE instead of FALSE The lookup_value doesn't exist within the first column of the table_array The table_array should reference B2:C5 The table_array should reference B2:C5 and the col_index_numb should be - 1 8 10 S What should Kareem do to fix the formula? B8 fx =VLOOKUP(A8,A2:C5,1,FALSE) B D E 1 Carrier 2 JB 3 DL 4 LH 5 AC 6 7 Airline 8 Delta Airline JetBlue Delta Lufthansa AirCanada Country US US GER CAN Carrier #N/A Change the table array to B2:05 Use the INDEX function instead Change the order of the columns This formula can not be fixed 9 10 Adam gets the #N/A! error from the MATCH formula described below. What could be the reason for the error? B12 fx =MATCH(A12, A2:09,0) D B Diameter (km) 5 Satelies 0 12 0 13 1 1 Planet 2 Mercury 3 Venus 4 Earth 5 Mars 6 Jupiter 7 Saturn 8 Uranus 9 Neptune 10 11 Planet 12 Earth 7 143 121 51 2 67 200 27 13 50 Position #N/A O the referenced range needs to be sorted (ordered alphabetically) The match_type is incorrect O not enough arguments passed to the match function The lookup_array reference is not a column or a row O The lookup_array reference should be anchored O The IFerror function should be used