Tuesday, March 3, 2015

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
1542KSab_1542_test1?
7788YWab_1542_test2?
5757SWab_6658_camp1?
1542KSab_5757_brand?
6658LWab_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
1542KSab_1542_test1KS
7788YWab_1542_test2KS
5757SWab_6658_camp1LW
1542KSab_5757_brandSW
6658LWab_7788_skyYW

Any help would be much appreciated.
------------------------------------------------------------------------------------------------------------------------------------------------