Wednesday, August 9, 2017

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   Aug-09-2017
question by Eliza Brennessel :!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: 

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!!