Match String from data in another sheet

[tahertalib]

Hi ,

I have a dataset which contains data in the below format:

CID	Task
300005913  Co12345 05AAAA101000268BBA00	T1
300005913  Cp67891 05BBBB101000270BBA00	T2
300005913  Cm11333 05CCCC101000283BBA00	T3
05WWWW101000287BBA00	T4
05WWWW101000289BLBBA00	T5

The second dataset which contains CID_new info:

CID_New

05AAAA101000268BBA00

05BBBB101000270BBA00

05CCCC101000283BBA00

05XXXX101000287BBA00

05QQQQ101000289BBA00

How can i lookup data from the 2nd dataset to 1st dataset? I want to add a new column in first data set(True or False) based on lookup results from second dataset.

If CID_New(Full string) is present in CID column from 1st dataset, it should return true.

Thanks

[tahertalib · Accepted solution]

Used the Find and Replace function and was able to get this working. Thanks