yogi_Pull Info From Another Sheet If Any Of The Specified Columns Contain A Specified Term

Google Spreadsheet   Post  #2222

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-09-2017

question by Eliza Brennessel :

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/YuVsWBYkIOg;context-place=mydiscussions

Auto Populate Data from Master, onto new sheet, validated by 5 possible different columns?

Hi there -

I have a MASTER list with the following columns: 

B:First

C: Last
D: Email 

E: Phone

F: DEPT 1 *data validated

G: DEPT 2 *date validated

H: DEPT 3 *data validated

I: DEPT 4 *data validated

J: DEPT 5* data validated

I would like to create a sheet that auto populates First, Last, Email, Phone, of anyone who has the letters "PC" in any of the "DEPT" columns (F:J).

Please help! I think it's an array formula, possible data lookup, but I'm so lost!

Thank you!!