IF formula shows #VALUE!

[dshafique]

Hi guys, i have a formula which checks the value of a cell in the "Unique ID" columns against the "Unique ID" column in a different table. if its the same, I have it say Keep, if it doesnt exist, i have it so it says delete. however, a third value I'm getting is #value !. any idea why im getting that value?

=IF([@UniqueID]=KPI[UniqueID],"Keep","Delete")

 

[StephenCrump]

Try: =IF(ISERROR(MATCH([@UniqueID],KPI[UniqueID],)),"Delete","Keep")

 

[dshafique]

thank you very much, this is exactly what I needed!

 

[StephenCrump]

You're welcome. I'm glad it worked for you.