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.

Improve this question
3
  • please edit & mention what's the "problem" you're facing and what have you tried
    – Sathyajith Bhat
    Commented 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 !
    – Jacob Jan
    Commented 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
    Commented Feb 24, 2013 at 3:43

1 Answer 1

Reset to default
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.

Improve this answer

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.