I want to find each occurance of a certain value in a worksheet. The value
can occur once or several times. Each time the value occurs, I need to list
related data.

Hlookup works great to find the first occurance, but how do I get it to find
the next occurance and then the next, etc?