Hi everybody, this is my first post here. I am completely stuck right now. I'm trying to create a formula to find out if data in column A can be found in column B.

So far what I have is: =IF(ISERROR(MATCH(A2,B:B,0)),"D","HA")
D mean Delete, HA means Has Assets

I thought this formula worked for me, but as I'm crunching through 3k+ pieces of data to ensure validity, I'm finding that not only is it telling me that certain pieces of data aren't found in column B when they are, but it's also not labeling D when appropriate. I'm completely stuck.

Any help is greatly appreciated, and please let me know if you need any more info!
Jocelyn