Hi,

My data is containing two columns as follows.

Column A Column B
112720, 112723, 112725 Yes
112355, 112353, 112358 No
45105000, 45105100 Yes

This is how my data exists. Now my working file is as follows:

Column A Column B
112723
112358
45105100

Now please suggest me that which formula I can use to get yes or no from data file in Column B of my working file.

Thanks in advance.

Vimala K