Question

In cell F₂, create a VLOOKUP formula that will look up the airport code in E2 and display the appropriate city name (using columns K and L). Look for an exact match?

Answer 1

To display the city name associated with an airport code in cell E2, use the formula =VLOOKUP(E2, K:L, 2, FALSE) in cell F2. It searches for an exact match in columns K and L.

Step-by-step explanation:

To create a VLOOKUP formula in cell F2 that looks up the airport code in E2 and displays the corresponding city name using columns K and L, you should enter the following formula:

=VLOOKUP(E2, K:L, 2, FALSE)

Here's how the formula works:

• E2 is the cell where the airport code is located that you want to look up.
• K:L indicates the range of columns where the first column K contains the airport codes and the second column L contains the city names.
• The number 2 indicates the second column in the range (column L) where the match will be returned from.
• FALSE specifies that you are looking for an exact match of the airport code.