Need If statement to compare two sets of data - stuck, sorry!

[absandme]

Hi.
I hate having to ask for help but I cannot work this out as the If statement is too long for my brain to cope with

I have two columns of data I need to compare.

Column A is old data, numerical (codes, eg 20183), rows 2 to 948

Column B is where I have tried to put the If statement.

Column C is where there is new numerical data (codes, eg 20183), rows 2 to 956


I need to
1 - if data was in old data, column A & also in new data, column C then column B should display the word "Edit"

Else:

2 - if data was in old data, column A but NOT in new data Column C then column B should display the word "Delete"

Else:

3 - if data was not in old data column A but is in New data, column C then column B should display the word "Add"


I think I'm right working it on the IF statement but I just cannot solve it, please help!

Many thanks in advance.

 

[iyyi]

For B2 try:
=IF(A2>0,IF(C2>0,"Edit","Delete"),IF(C2>0,"Add",""))

 

[absandme]

Thanks but I need to adjust it slightly.

My original If statement was:

=IF(ISNUMBER(MATCH(A2,$C$2:$C$956,0)),"TRUE","FAIL")

This meant that it would search the whole column for a match to be true/fail & then I changed it to Edit...... I then realised I needed to write an If statement with more information as the original question, Edit, Add & Delete but it needs to search the whole list of data.

Can I please have some more help?
Thanks

 

[konew1]

i don't think you can do that in one column. If you use column B, starting with B2 to check that A2 is either in col C or not in Column C, you then need to use a different column to check if column C data is also in column A