How to display an "X" in a cell if A:A on sheet one is equal to A:A on sheet 2

[Harrywatson]

For example if the number 412 appears on sheet 2 somewhere in column A and 412 is also somewhere in column A on sheet one. How do I make a big bold X to appear in sheet one in the column J in the same row as the number 412? Help would be appreciated, I am struggling on excel!Thanks a lot

Example: 412 is in A43 in sheet one... 412 has now appeared in sheet two at A23. I would now like an X to be displayed in Sheet one J43. Many Thanks

 

[timfritsch]

For sheet 1, cell J1, try:

=IF(ISERROR(MATCH(A1,Sheet2!A:A,0)>0),"","X")

Hope this helps.


Tim