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

A

Austin George

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 whatthe 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 theperson 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!
 
D

Don Guillett

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 downthe '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!
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Use a variable in a ShapeRange.Increment 0
Dynamic Naming of Form Button 3
Extracting a cell value 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Adding a big matrix in Word 2013 5
Drop down lists in seperate columns 5
Autonumber field in Excel that behaves the same as Access 0

Top