| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy last cell with data in column E on one sheet to cell on anoth | Excel Worksheet Functions | |||
| VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column | Excel Programming | |||
| Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
Linear Mode
