"If a cell contains x from a large separate table, then fill cell with y"

[KerryD123]

Hi there, 

Wondered if this was possible.

I am working on an aviation spreadsheet and have created a table of Callsigns and their respective airlines.

So this separate table is as follows

In column A is the callsign prefix and in column 2 is the full name of the airline:

So A2= BAW and B2= British Airways

A3= DLH and B3 = Lufthansa

etc.

Now looking at the main logging spreadsheet, I want the first column to be the callsign (e.g BAW341) and the second column to reference the callsign table, see that the first cell contains "BAW" and automatically fill the second column with the respective airline (British Airways).

Is this possible?

Thanks in advance!

[#2]

@KerryD123 Could be done with an easy VLOOKUP if the airline is always designated by the first 3 characters of the callsign, as shown in the attached picture. 

If not, please come back with a sample of your data.