Copy corresponding cell in Column B if cell in A contains certain text?
 

I have two columns labeled "service" and "other" on sheet A. One of the drop down options in the 'service' column is to select Other - then enter what the other service was in the next cell. I need a formula that looks down the 'service' column - finds anytime Other was selected then copies what the person entered into a column on sheet b. So i will have a list on Sheet B of all of the 'other' entries someone has made. Does that make sense? Thanks for the help!

Copy corresponding cell in Column B if cell in A contains certain text?
 

On Thursday, May 1, 2014 11:32:03 AM UTC-5, Austin George wrote:
I have two columns labeled "service" and "other" on sheet A. One of the drop down options in the 'service' column is to select Other - then enter what the other service was in the next cell. I need a formula that looks down the 'service' column - finds anytime Other was selected then copies what the person entered into a column on sheet b. So i will have a list on Sheet B of all of the 'other' entries someone has made. Does that make sense? Thanks for the help!

NO. If desired send your file to dguillett @gmail.com and I'll take a look.