Vlookup help!

I have a question I'm totally stumped on. The workbook I use doesnt detail how to perform both functions correctly. Can anyone please help? Thanks

In the Filtered List sheet, click cell A2. Insert a VLOOKUP function to lookup the airline in the Departures sheet, compare it to the airline table in the Airline Codes sheet, and return the code for that airline. For example, Unified will display as UNA. (The function should copy to the range A3:A29 automatically.)

Hi Kaleid20, an example workbook is always helpful.

Here is screenshot of the workbook.

Untitled1.png
Untitled2.png
Untitled3.png

Hi Kaleid20, try this in cell A2 and copy it down.

=vlookup('Departures'!A2,'Airline Codes'!$A$2:$B$5,2,0)

That worked great! Can I get help with one more?

In the Filtered List sheet, click cell C2. Use a text function to display the cities from the Departures sheet where the first letter is capitalized but the remaining letters are lowercase, such as Houston. (The function should copy to the range C3:C29 automatically.)

Of course you can, fire away.

Lol - I didn't spot that you had posted the query below. I'll read it now.....

Try =PROPER('Departures'!C2)

Yup, but for review purposes. It's all online so not a lot of chance for assistance, etc.

Hi, I am trying to do the same homework, however it does not work? Not sure why? I enter exactly what you stated?