This preview shows pages 1–2. Sign up to view the full content.
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
This note was uploaded on 02/26/2009 for the course CSE 1520 taught by Professor Kemeny during the Fall '08 term at York University.
- Fall '08