Formula for finding a number in a cell containing multiple numbers

[bhn319]

Ex: Column F contains multiple cells & numerous numbers in each cell. Column A contains 1 number in each cell. I would like a formula that will search column F for one of the numbers listed in column A and indicate yes or no if found in another cell

Column A-------------Column F---------------- Column H
1 7055 ------7050, 7052, 7053, 7059, 7060
2 7056 ------7029, 7045, 7011, 7062, 7051
3 7059 ------7001, 7004, 7065, 7077, 7080
4 7062 ------7044, 7035, 7055, 7010, 7099
5 7063 ------7019, 7063, 7002, 7064, 7056 ---(formula needed)
6 7064
7 7065

Example I select Cell A4(7062) I want to search all of Column F to find A4(7062) and then indicate yes or no in a cell in column H

 

[Weaver]

=IF(ISERROR(FIND(A4,F4)),"No","Yes")

 

[Yahya]

Try this way

Excel Workbook
	A	B	C	D	E	F	G	H
1	Column A					Column F
2	7055					7050, 7052, 7053, 7059, 7060		Yes
3	7056					7029, 7045, 7011, 7062, 7051		Yes
4	7059					7001, 7004, 7065, 7077, 7080		Yes
5	7062					7044, 7035, 7055, 7010, 7099		Yes
6	7063					7019, 7063, 7002, 7064, 7056		Yes
7	7064							Yes
8	7065							Yes
Sheet9

Excel 2007

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[John Davis]

Ex: Column F contains multiple cells & numerous numbers in each cell. Column A contains 1 number in each cell. I would like a formula that will search column F for one of the numbers listed in column A and indicate yes or no if found in another cell

Column A-------------Column F---------------- Column H
1 7055 ------7050, 7052, 7053, 7059, 7060
2 7056 ------7029, 7045, 7011, 7062, 7051
3 7059 ------7001, 7004, 7065, 7077, 7080
4 7062 ------7044, 7035, 7055, 7010, 7099
5 7063 ------7019, 7063, 7002, 7064, 7056 ---(formula needed)
6 7064
7 7065

Example I select Cell A4(7062) I want to search all of Column F to find A4(7062) and then indicate yes or no in a cell in column H

Maybe:
=IF(ISNA(VLOOKUP("*" & A1& "*",$F$1:$F$7,1,FALSE)),"No","Yes")

 

[bhn319]

Thank you very much all suggestions were greatly appreciated!!

 

[Peter_SSs]

Assuming they are all 4 digit numbers, here's another option to consider.

Excel Workbook
	A	B	C	D	E	F	G	H
1
2	7055					7050, 7052, 7053, 7059, 7060		Yes
3	7056					7029, 7045, 7011, 7062, 7051		Yes
4	1111					7001, 7004, 7065, 7077, 7080		No
5	7062					7044, 7035, 7055, 7010, 7099		Yes
6	2020					7019, 7063, 7002, 7064, 7056		No
7	7064							Yes
8	7065							Yes
9
Check Number Exists