Find the next occurance
I'll give that a try. Thanks.
"T. Valko" wrote:
However, there is related data in up to 45 rows.
Ugh! A formula method probably isn't the best way to go. Maybe a pivot table
?????
--
Biff
Microsoft Excel MVP
"Lou" wrote in message
...
The look up values are in row 1. The related data that I need is in rows
3, 4
and 5. However, there is related data in up to 45 rows. I am trying to
get
the look up values and related data listed in a seperate worksheet as a
summary.
Thanks
"T. Valko" wrote:
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?
|