{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# DD - City column for the Destination of each flight City[8...

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

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

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

View Full Document
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

{[ snackBarMessage ]}

### Page1 / 2

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

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

View Full Document
Ask a homework question - tutors are online