radonwilson
Board Regular
- Joined
- Jun 23, 2021
- Messages
- 50
- Office Version
- 2019
- Platform
- Windows
- In Trans_Type Col, I have 3 transaction types i.e. Order, Shipping Services & Refund.
- Now, some Order_IDs of Order (Trans_Type) are matching with Refund (Trans_Type), I want to tag these matched as "Found" and the rest as "Unfound" in Custom Column.
| Demo.xlsx | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Trans_Type | Order ID | Helper/Custom Column | ||
| 2 | Order | 111 | Not Found | ||
| 3 | Shipping Service | 111 | Not Found | ||
| 4 | Refund | 999 | Found | ||
| 5 | Shipping Service | 222 | Not Found | ||
| 6 | Order | 222 | Found | ||
| 7 | Order | 333 | Not Found | ||
| 8 | Order | 444 | Not Found | ||
| 9 | Order | 555 | Found | ||
| 10 | Order | 666 | Not Found | ||
| 11 | Order | 777 | Found | ||
| 12 | Order | 888 | Not Found | ||
| 13 | Order | 999 | Found | ||
| 14 | Refund | 777 | Found | ||
| 15 | Shipping Service | 333 | Not Found | ||
| 16 | Shipping Service | 444 | Not Found | ||
| 17 | Shipping Service | 555 | Not Found | ||
| 18 | Shipping Service | 999 | Not Found | ||
| 19 | Refund | 222 | Found | ||
| 20 | Refund | 555 | Found | ||
| 21 | Refund | 2121 | Not Found | ||
| 22 | Shipping Service | 666 | Not Found | ||
| 23 | Shipping Service | 777 | Not Found | ||
| 24 | Shipping Service | 888 | Not Found | ||
| 25 | Refund | 4242 | Not Found | ||
| 26 | Refund | 3939 | Not Found | ||
| 27 | Refund | 5757 | Not Found | ||
Sheet1 | |||||
