I want to find all cell values in column 'A' with, let's say a value "gmail.com" and replace all values of column B with "EN" (change the value in the same row of A and B result).
Is there a function that does this?
I want to find all cell values in column 'A' with, let's say a value "gmail.com" and replace all values of column B with "EN" (change the value in the same row of A and B result). Is there a function that does this? 

migrated from stackoverflow.com Dec 10 '12 at 11:01This question came from our site for professional and enthusiast programmers. 


For a partial search try something like 


Use an
This will look for the To copy it down all the rows in the column, double click on the bottom right corner of the cell where the drag cross is. 


Use Select column A and B (entirely) and apply the (auto)filter; select filter options on column A and chose text filters: contains. Set contains to "gmail.com", and apply filter. Column B will be filtered accordingly. Change the first cell in column B, and copy it (Ctrl C). Then select the remaining cells in column B and press Ctrl V. 

