Page 2 - In Excel how to search a text string + get TRUE/FALSE result

Hi,
I'm in a similar but slightly different situation and would love if someone could help me out here.

In a spreadsheet, I have in Sheet1 with column A consisting of string values which have special characters (!,$,%,etc.)
Sheet2 has a list of the special characters in it's column A

I want to find out for each row in Sheet1 which special character(s) are present by matching the list of special characters in Sheet2.

Would appreciate anyone's input. Thanks!

so i have a bunch of data across 7 sheets the first 6 is whether or not certain tests pass in certain way and the last sheet is a over view of how many passed and failed.

details of testing set up
lot of items to be tested(sheet 7)
individual items test data (sheets 1-6)
these sheets have a lot number that is also on sheet 7

i think that this may need to make a function but not sure.

i want to have sheet 7 update automatically with overall pass and fail numbers as new data is put into sheets 1-6 via finding the lot number and then look at that row for weather or not it passed or not.

sheet 7 example
LOT # Total Units Tested Passed Failed
F203 1029 947 369 578


sheet 1-6 example
LOT# test1 test2 test3 pass/fail
F203 p p f fail
F203 p p p pass

Hi, I'm using the above to find a tilde "~" and would like to also have the formula return the position of the tilde.
Can you show me how to combine
=IF(IF(ISERROR(FIND("~",B2)),"Not found", "Found")

with

SEARCH(b2,"~",1)

I tried this, but getting #VALUE!:
=IF(IF(ISERROR(FIND("~",B2)),"Not found", "Found")="Found",SEARCH(B2,"~",1),"")