yogi_Pull Flight Sales Info From Table In Columns A and Based On Booking Info Embedded In Flight Info In Column C

             Google Spreadsheet   Post  #1906

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-03-2015
question by Dominic sheets:
https://productforums.google.com/forum/#!mydiscussions/docs/htf99gP6xRQ
Trying to match

Hi all

I've got 4 Columns each has over a thousand rows:

Booking:	Sales:	Flight:	Flightsales
1542	KS	ab_1542_test1	?
7788	YW	ab_1542_test2	?
5757	SW	ab_6658_camp1	?
1542	KS	ab_5757_brand	?
6658	LW	ab_7788_sky	?

However I need a function in the "Flightsales" column, which checks if the number in the "booking" column is contained in one or multiple cells of the "flight" collumn if it finds a match it has to return the corresponding "sales" value and in the end should look something like this:

Booking:	Sales:	Flight:	Flightsales
1542	KS	ab_1542_test1	KS
7788	YW	ab_1542_test2	KS
5757	SW	ab_6658_camp1	LW
1542	KS	ab_5757_brand	SW
6658	LW	ab_7788_sky	YW

Any help would be much appreciated.

------------------------------------------------------------------------------------------------------------------------------------------------