This preview shows page 1. Sign up to view the full content.
Unformatted text preview: The information in the other columns is extracted by formulae. 1. Create the formula necessary to populate the Airport column for the Origin of each flight.  =LOOKUP( LEFT( Flight_Codes, 3), IATA_Code , Airport )) 1 mark for each underlined component 2. Could this have been done using an IF function? BRIEFLY explain. No. It would require more than 7 nested IFs. D1...
View Full Document
- Spring '09