ChrisParkinson
New Member
- Joined
- Dec 12, 2019
- Messages
- 3
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi All,
Hope somebody can help me, i have a problem.
I have some data - see below, i want to return a specific value if a cell contains certain text.
So for example if my cell Orderitems contains the text SDA1654 & SDA1585 & SDA1576 the return SDA1000
Any help would be appreciated.
Chris
Hope somebody can help me, i have a problem.
I have some data - see below, i want to return a specific value if a cell contains certain text.
So for example if my cell Orderitems contains the text SDA1654 & SDA1585 & SDA1576 the return SDA1000
Warehouse | Channel | OrderItems |
Main Warehouse | Studio | SDA1654:4;SDA1585:4;SDA1576:4; |
Wrexham Warehouse | Studio | SDA1655:1;SDA1586:1;SDA1577:1; |
Dropship Warehouse | Studio | SDA1656:1;SDA1578:1;SDA1587:1; |
Any help would be appreciated.
Chris