Helper Column For Matching Values

[radonwilson]

1. In Trans_Type Col, I have 3 transaction types i.e. Order, Shipping Services & Refund.
2. 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.

How to create a helper 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

 

[Fluff]

Duplicate to: Custom Column For Matching Values

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.