Answer:
Step-by-step explanation:
To retrieve the name of the arrival city for the flight in cell F3 using the VLOOKUP function and then copy the formula down to cell F6, follow these steps:
Select cell F3 in the Requests worksheet.
In the formula bar, enter the following formula:
=VLOOKUP(E3, Flights!A:B, 2, FALSE)
Here, E3 represents the flight number in cell E3, Flights!A:B refers to the range in the Flights worksheet where flight numbers and corresponding arrival cities are stored, 2 indicates that the arrival city is in the second column of the range, and FALSE ensures an exact match for the flight number.
Press Enter to apply the formula to cell F3. The arrival city for the flight in E3 will be displayed.
To copy the formula down to cell F6, select cell F3, hover the cursor over the bottom-right corner of the cell until it turns into a crosshair cursor, and then drag it down to cell F6. The formula will be automatically adjusted for each row, retrieving the respective arrival city based on the flight number in column E.
Ensure that the Flights worksheet contains the flight numbers and corresponding arrival cities in columns A and B, respectively, and that the worksheet name is spelled correctly in the formula. Adjust the range (Flights!A:B) accordingly if your data is located in a different range or worksheet.