I am trying the second option and typing in this forumla where I would like the 1 to show.

=IF(A3=MTrack!A$2:A$152,1,"")

The goal is that if cell A3 is anywhere in column A of the MTrack worksheet a 1 will show up. All I am getting are blanks, and I know that some many should be 1's.

What is wrong??