Sheet 1 only contains a column of numbers, from A1 to A739.

Sheet 2 contains a column of numbers in column A, some that will be the same as numbers from Sheet 1 and some won't. Next to this column is another that is for the formula. I need to come up with a formula that will look at the number next to it in column A and then go down Sheet 1's column to find if any of the numbers match it. Sounds simple, right?

At the moment, this is my formula:
=IF(A2='Sheet 1!A1:A739,"Match","")

You would think this would work, but it doesn't. Instead I get #VALUE!. I tested this formula in a blank spreadsheet with fake numbers, and it worked. I think it's not working in mine though because my numbers are from a report (all of Sheet 1's numbers are imported from some other source, I don't know where). The numbers also have a data range name called "numpros" if that means anything. This may make things more difficult.

I can get the formula to work if I find a match, then test it out with the following formula:
=IF(A2='Sheet 1!A16,"Match","")

But when I try to do a data range again, it won't work. Also, if I manually try to grab the data range by clicking on the tab and scrolling down, it won't let me click on the first cell (which has a click down arrow to filter, sort, and customize). Even with the rest of the cells picked, the formula still doesn't work.

I've also tried this formula, but it ends up saying that none match and gives me a bunch of blank cells (when I know that some do match):
=IF(A2='Sheet 1!A:A,"Match","")


To make it short, I've tried everything I can think of. I'm not a guru at handing information put into excel from another report, and I was wondering what I'm missing (by the way, I have changed all columns formats to "general", so it's not that either).

Much appreciated!