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

%3CLINGO-SUB%20id%3D%22lingo-sub-1513691%22%20slang%3D%22en-US%22%3E%22If%20a%20cell%20contains%20x%20from%20a%20large%20separate%20table%2C%20then%20fill%20cell%20with%20y%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513691%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondered%20if%20this%20was%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20an%20aviation%20spreadsheet%20and%20have%20created%20a%20table%20of%20Callsigns%20and%20their%20respective%20airlines.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20this%20separate%20table%20is%20as%20follows%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20column%20A%20is%20the%20callsign%20prefix%20and%20in%20column%202%20is%20the%20full%20name%20of%20the%20airline%3A%3C%2FP%3E%3CP%3ESo%20A2%3D%20BAW%20and%20B2%3D%20British%20Airways%3C%2FP%3E%3CP%3EA3%3D%20DLH%20and%20B3%20%3D%20Lufthansa%3C%2FP%3E%3CP%3Eetc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20looking%20at%20the%20main%20logging%20spreadsheet%2C%20I%20want%20the%20first%20column%20to%20be%20the%20callsign%20(e.g%20BAW341)%20and%20the%20second%20column%20to%20reference%20the%20callsign%20table%2C%20see%20that%20the%20first%20cell%20contains%20%22BAW%22%20and%20automatically%20fill%20the%20second%20column%20with%20the%20respective%20airline%20(British%20Airways).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1513691%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1514134%22%20slang%3D%22en-US%22%3ERe%3A%20%22If%20a%20cell%20contains%20x%20from%20a%20large%20separate%20table%2C%20then%20fill%20cell%20with%20y%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F724468%22%20target%3D%22_blank%22%3E%40KerryD123%3C%2FA%3E%26nbsp%3BCould%20be%20done%20with%20an%20easy%20VLOOKUP%20if%20the%20airline%20is%20always%20designated%20by%20the%20first%203%20characters%20of%20the%20callsign%2C%20as%20shown%20in%20the%20attached%20picture.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-07-10%20at%2013.03.29.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204568iE65C41D7FBFF19F4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-07-10%20at%2013.03.29.png%22%20alt%3D%22Screenshot%202020-07-10%20at%2013.03.29.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20not%2C%20please%20come%20back%20with%20a%20sample%20of%20your%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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!

 

1 Reply
Highlighted

@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. 

Screenshot 2020-07-10 at 13.03.29.png

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