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

You have to use a different formula.

Where are the lookup_values? Are they sorted so that they might be grouped
together? Where is the related data that you want returned?

--
Biff
Microsoft Excel MVP


"Lou" wrote in message
...
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?