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
This note was uploaded on 12/16/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.
- Spring '09