With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.energyefficientbuild.com. Mar-03-2015 question by Dominic sheets: https://productforums.google.com/forum/#!mydiscussions/docs/htf99gP6xRQ Trying to match
I've got 4 Columns each has over a thousand rows:
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: