DD - City column for the Destination of each flight. City...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
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. The  International Air Transport Association (IATA)  uses 3 letter codes to identify airports. The table  below lists information for a few Canadian airports. In the worksheet below, Flight Codes contain information about the Origin and destination of the flight.  This information is derived by formulas in the other columns. Create the formula necessary to populate the 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: City column for the Destination of each flight. City [8] =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.

Page1 / 2

DD - City column for the Destination of each flight. City...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online