What is the correct lookup formula for cell B6 to find the airline name based on its code in A6 Assume that the airline code can always be found, i e , do not worry abou t lookup err ors 1 JB 2 DL 3 LH 4 AC JetBlue Delta Lufthansa AirCanada 6 DL

Question

What is the correct lookup formula for cell B6 to find the airline name based on its code in A6  Assume that the airline code can always be found, i e  , do not worry abou t lookup err ors 1 JB 2 DL 3 LH 4 AC JetBlue Delta Lufthansa AirCanada 6 DL

Accepted Answer

The Answer is in the image, click to view ...

Question

What is the correct lookup formula for cell B6 to find the airline name based on its code in A6? Assume that the airline code

What is the correct lookup formula for cell B6 to find the airline name based on its code in A6? Assume that the airline code can always be found, i.e., do not worry abou t lookup err ors
1 JB 2 DL 3 LH 4 AC JetBlue Delta Lufthansa AirCanada 6 DL

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI