a simple find macro should help. Modify to suit
Sub findem()
For Each c In Range("e7:e" & Cells(Rows.Count, "e").End(xlUp).Row)
c.Offset(0, 1) = Columns("h").Find(c).Offset(0, 1)
Next
End Sub

--
Don Guillett
SalesAid Software

"Oreg" wrote in message
...

Hello,

Pulling what's left of my hair out trying to come up with a solution.
I have a column (G), with a list of IDs (IWEC44332). Each ID has 2
numbers associated with it in another column (F). I would like to
create a macro or function to search column G and list both numbers
associated with the ID #. Displaying those numbers either together in
1 column (H) or 2 columns (H & I). Is this possible ???


--
Oreg
------------------------------------------------------------------------
Oreg's Profile:
http://www.excelforum.com/member.php...fo&userid=9195
View this thread: http://www.excelforum.com/showthread...hreadid=380308