punksterz626
New Member
- Joined
- Jun 30, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello Colleagues,
Hoping everyone is doing well. I'm having a hard time creating a formula that meets this scenario, hoping someone can help me.
I have multiple columns in the sheet, but to simplify I'll just list the columns that pertain to this scenario. I want to do a search criteria in the Description column, but only if Type column is "ShoeSales", if not just leave blank. Is this possible?
Hoping everyone is doing well. I'm having a hard time creating a formula that meets this scenario, hoping someone can help me.
I have multiple columns in the sheet, but to simplify I'll just list the columns that pertain to this scenario. I want to do a search criteria in the Description column, but only if Type column is "ShoeSales", if not just leave blank. Is this possible?
Type | Description | Search Criteria | Result Wanted FOR ShoeSales |
ShoeSales | SS project ABCD | if column A =ShoeSales & Description has "ABCD" | SS ABCD |
PantSales | PS project ABCD | ||
ShoeSales | SS project ABCD | if column A =ShoeSales & Description has "ABCD" | SS ABCD |
ShoeSales | SS project M&S | if column A =ShoeSales & Description has "M&S" | SS M&S |
ShoeSales | SS project TTD | if column A =ShoeSales & Description has "TTD" | SS TTD |
PantSales | PS project |