Check for a value in a large table and return 'Y' or 'N'

Hello
I'm having difficulty in working out a solution to my problem, I have tried using Match or Index but they seem to refer to single columns or rows. The problem is that I have a large table of four digit numbers in each cell, this table could be 100 columns wide by 50 rows, that doesn't really matter. I also have a separate table with one column of four digit numbers. I want to look at the single column of numbers for the value and see if it exists anywhere in the large table, I don't need to count it or anything else other than check to see if it exists, if it does then 'Y', if not then 'N'. Example image attached but I'm afraid I have no formulae as anything I try doesn't work.
Thanks in anticipation.

excelimage.jpg

Use countif
for example, data is in A1:Z100, then in AA1 you have the value to search for, in AA2:
=if(countif(A1:Z100,"="&AA1)>0,"Y","N")

I moved the numbers from A5:A10 to G1:G6, and then used this formula in H1:

=IF(COUNTIF(A:D,G1)>0,"Y","N")

which can then be copied down. If you have 50 columns of data, you will need something like this:

=IF(COUNTIF(A:AX,AZ1)>0,"Y","N")

with the numbers that you are looking for in column AZ, and the formula in BA1.

Hope this helps.

Pete

Thank you to all of you, I couldn't see the wood for the trees.