0

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 – Sathyajith Bhat Feb 21 '13 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 ! – Jacob Jan Tuinstra Feb 21 '13 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 '13 at 3:43
1

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

=if(iserror(find(C$1,$B2)),"",1)  

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, privacy policy and cookie policy

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