I have problem in reading cell with multiple values and comparing the each value with column from a-z if match found then set value of the cell has '1'.

Problem: I need to take multiple company names in the list and take one company and look for the same in the columns if match is found then set the value as 1 and read each consecutive columns.

Please find a sample spreadsheet: sample sheet. Currently I'm learning Google scripting so I need your help.

  • please edit & mention what's the "problem" you're facing and what have you tried Feb 21, 2013 at 4:09
  • Can you share a Google Spreadsheet with us and show the expected result? Try editing your question and add the Google Spreadsheets tag also to it. Good luck ! Feb 21, 2013 at 6:14
  • Thanks for your feed backs to both of you.....now i have linked the spreadsheet u can have look and suggestion how to proceed?
    – preeti
    Feb 24, 2013 at 3:43

1 Answer 1


I have assumed the last two rows are incomplete rather than a guide to your requirement, so would suggest:


in the column labelled aaa and the row labelled abc, copied across and down to suit.

Your Answer

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

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