This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: City column for the Origin of each flight. City  =LOOKUP( LEFT( Flight_Codes, 3), IATA_Code , City ) & ", " & 08f223768a6ba53547c9269cc17b5029feed103c.doc Part D –Excel LOOKUP Formulas [7 points] Use only the data shown to answer the following questions. All ranges have been named using the labels that appear in the worksheets. LOOKUP( LEFT( Flight_Codes, 3), IATA_Code, Province ) 1 mark for each underlined component 08f223768a6ba53547c9269cc17b5029feed103c.doc...
View Full Document
- Fall '08