Searching an array with an array

[katburglar007]

Required outcome: True/False
Problem: I have 2 excel worksheets, both with >1000 alphanumeric codes spread across rows and columns. I want to see if ANY of the codes in Sheet 1 Row 1 Match ANY of the codes in ALL columns and rows (entire array) in Sheet 2 and return a True/False (yes/no, 1/0, doesn't really matter). Then check Sheet 1 Row 2 etc.
I'm sure this is an array formula using INDEX and MATCH but I just can't figure it out.
Thanks

[benishiryo]

welcome to the forum, katburglar007. do upload an excel sample so that we do not have to manually key in your data to do a testing.
input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

assuming the alphanumeric in Sheet2 is cell A2, my guess is you can use
=COUNTIF(Sheet1!A:A,A2)
or if in multiple columns:
=COUNTIF(Sheet1!A:Z,A2)

it will count how many instances of A2 did it appear in Sheet1 column A to Z. to make it TRUE or FALSE,
=COUNTIF(Sheet1!A:A,A2)>0