I'm using a formula to search for a term within a cell and populate the correlating name into a cell on a connected sheet. The sheet1 (form responses) would be populated by data from a form. sheet2 (Saturday and Sunday) is to insert the names into the empty cells so people know those spots are taken and don't try to select them. But I can't get it to work anymore and I'm totally lost as to why

It works in some cells but not others. What I have figured out is the person in the first row will populate correctly for the class in the first column after the name field and so on (Name one only works in class 1, Name 2 only works in class 2 etc.)

=IF(ISNUMBER(SEARCH(term,rage of cells in sheet1)), correlating name of that row, )
  • Welcome. Please read how to and share a test sheet so as you can be easier helped (data should be not too much and make sense as well). Also. Please do share the form (after filling in a few replies). Jan 31, 2021 at 6:29
  • I updated the editing capabilities. Jan 31, 2021 at 23:17

1 Answer 1


I seem to have figured it out using INDEX and MATCH instead of Search.

  • That is great. Please edit your answer, including your solution. Feb 1, 2021 at 20:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.