yogi_Look For Student Name In Several Columns And Mark YES If The Student Has Taken The Quiz

Google Spreadsheet   Post  #2165

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

question by KathleenWatson4s:

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

Looking to search several columns with array formula

I am hoping I can find someone to help!

I have a google form quiz and it asks what students are in which classrooms as different questions. They end up in spreadsheet in different columns. I am trying to figure out a way to use the search function to pick up their names in all the possible columns their name could appear in

Here is a mock spreadsheet mirroring what I am trying to do!

https://docs.google.com/spreadsheets/d/1EldzwHBfpsOHL0PgPkL9oM_hsb0kayUaLUfzR9Hg6kQ/edit?usp=sharing