Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

share|improve this question
    
please edit & mention what's the "problem" you're facing and what have you tried –  Sathya 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 Answer 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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