formula to search a column of cells and retrieve item

[bhn319]

How can I have excel search a column in which each cell contains multiple numbers (ex column f) for a number that is in a particular cell (ex A61)?

 

[T. Valko]

How can I have excel search a column in which each cell contains multiple numbers (ex column f) for a number that is in a particular cell (ex A61)?

Can you post some sample data?

Also, what do want to do once you find this number?

 

[jim may]

With oversimplified Sheet1, like so..

Excel Workbook
	A	B	C	D	E	F
1	Look For Multiple of					MyNums
2	33					10
3						20
4						33
5						40
6						45
7						55
8						66
9						77
10						99
Sheet1

Excel 2007

Paste this code into a Standard module and run it:

Sub Foo()
LR = Range("F" & Rows.Count).End(xlUp).Row
Set Rng = Range("F2:F" & LR)
For Each c In Rng
    r = c.Value Mod Range("$A$2")
    If r = 0 Then
        temp = temp & "," & c.Address
    End If
Next c
MsgBox Right(temp, Len(temp) - 1)
End Sub

Does this work for you?