Match Debit and Credit in different columns

[askall1000]

Hello to all,

I need a help of a easy problem but could not solved with IF, AND or OR function. Any help will be appreciated. My required aim is match the debit and credit, if they match in third column (Target) TRUE will be shown. Thank you very much in advance and sorry to upload photo because working laptop not allow add-ins for excel.

Debit	Credit	Target
	54.022,61​	TRUE​
54.022,61​		TRUE​
	173.251,71​	TRUE​
173.460,82​		TRUE​
	97.756,96​	TRUE​
	209,11​	FALSE​
97.756,96​		TRUE​
	251.854,34​	TRUE​
	251.854,34​	TRUE​
251.854,34​		TRUE​
251.854,34​		TRUE​
	67.210,40​	TRUE​
67.210,40​		TRUE​
38.672,89​		TRUE​
	38.672,89​	TRUE​
	1.152,80​	TRUE​
1.152,80​		TRUE​
	97.365,97​	TRUE​
97.365,97​		TRUE​
64.773,06​		FALSE​
10.685,31​		FALSE​
162,84​		FALSE​
141,60​		FALSE​
509,76​		FALSE​
2.561,39​		FALSE​
	16.017,91​	FALSE​

 

[somesoldiers]

Hi

put this formula in Target col row 2 and pull down as far as needed

=IF(OR(COUNTIF(A:A,B3)>=1,COUNTIF(B:B,A3)>=1),TRUE,FALSE)

note your sample has TRUE for 173.251,71 AND 173.460,82 which isn't correct

 

[askall1000]

Hi

put this formula in Target col row 2 and pull down as far as needed

=IF(OR(COUNTIF(A:A,B3)>=1,COUNTIF(B:B,A3)>=1),TRUE,FALSE)

note your sample has TRUE for 173.251,71 AND 173.460,82 which isn't correct

Thank you very much for your help, it is what i needed.