willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 893
- Office Version
- 365
- Platform
- Windows
Hello,
I am not even sure if this is possible but am hoping someone can help me write a formula that can match text and return the value from another column.
The problem is what I need matched is a numberic 6 digit number always following rather: "WO " or "W/O "
Any help would be greatly appreciated!!
Here is an example of the data and a picture of where I want to put the formula:
I am not even sure if this is possible but am hoping someone can help me write a formula that can match text and return the value from another column.
The problem is what I need matched is a numberic 6 digit number always following rather: "WO " or "W/O "
Any help would be greatly appreciated!!
Here is an example of the data and a picture of where I want to put the formula:
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | WO# | PO# | ||
2 | 110500 | |||
3 | 140899 | |||
4 | 106270 | |||
5 | 117953 | |||
6 | 110222 | |||
7 | 175123 | |||
Sheet1 |
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | PO# | Notes | ||
2 | 4696 | PLEASE SHIP FEDEX WO 117953 | ||
3 | 4697 | W/O 106270 SHIP FEDEX | ||
4 | 4698 | SHIP FEDEX ACCOUNT XXXX999WO 140899 | ||
5 | 4699 | Please ship fedex | ||
6 | 4700 | Account# XXXXXX | ||
7 | 4701 | WO 110500 replacement | ||
8 | 4702 | Economy | ||
Sheet2 |