This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: City column for the Destination of each flight. City  =LOOKUP( RIGHT( Flight_Codes, 3), IATA_Code , City ) & ", " & LOOKUP( RIGHT( Flight_Codes, 3), IATA_Code, Province ) 35d58b37f4dfa8539eb17935252dbba8bf5d538b.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. 1 mark for each underlined component 35d58b37f4dfa8539eb17935252dbba8bf5d538b.doc...
View Full Document
- Fall '08
- Following, International Air Transport Association, IATA, –Excel LOOKUP Formulas