Saturday, September 14, 2013

yogi_Return Row1 Value of The Associated Column Where A Specified name Occurs

                                          Google Spreadsheet   Post  #1369
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Sep 10, 2013
user malvaoo (!category-topic/docs/spreadsheets/BRu_U2OoER0)
HELP: Formula to return only ROW 1 values that contain a specific value in their columns?
Example: A1 has "Event 1", B1 has "Event 2", C1 has "Event 3." 

Let's say "John" is listed somewhere (could be anywhere) under Event 1 and 3, but not 2. I want a single formula to return all the events John is listed under. If the formula is in G1, I want it to return "Event 1" in G1 and "Event 3" in H1 (Event 2 is skipped).

Any help? :D