How to find if the items are in original page

[jackson_hollon]

Hello,

Thanks in advance for helping. I have attached a file here. There are 2 tabs. I am looking for a famular that will put a "Y" in column D on Sheet2 if the values on column A and B are found in Orignal tab. Otherwise, if will put a "N" if the values ae not find. I hope what I said here makes sense.

Thanks again.

[BadlySpelledBuoy]

This in D2 and copied down would work:

Please Login or Register  to view this content.

However, your data is in need of attention. For example B2 on Original has trailing spaces which means it does not match row 2 on Sheet 2.

Tidy up the trailing spaces and the above will work.

BSB

[jackson_hollon]

BadlySpelledBuoy,

It works. Thank you!

[kvsrinivasamurthy]

In D2 then drag down

Please Login or Register  to view this content.

Extra spaces are there in B column of Original sheet.

[BadlySpelledBuoy]

Glad I could help.

Thanks for the rep.

BSB