Hello All,

I have an array of data in columns G:K. I need to extract certain
information based on criteria that appears in column I. Easy, right?
The problem is that the data does not appear on every record that needs
to be extracted. Basically, the data that I want to pull has a starting
point (the criteria) and an end point within the column and may appear
multiple times. I only want to pull out the data in the rows from the
start to end point criteria so I guess the lookup needs to be triggered
by the start point. The other issue is that there are multiple end
points. My data appears like this:

G H I J K
1 ASSTCTR FWYDONE 5305TRNMT WPC 257066
2 ASSTCTR FWYDONE INDEXERROR WPC 257066
3 ASSTCTR FWYDONE TRINCSGL WPC 257066
4 ASSTCTR FWYDONE TRINCSGL THB 262943
5 ASSTCTR FWYDONE 4539REORG AKI 238976
6 ASSTCTR FWYDONE INDEXERROR AKI 238976
7 ASSTCTR FWYDONE TRINCSGL AKI 238976
8 ASSTCTR FWYDONE TRINCSGL 3423 241789
9 ASSTCTR FWYDONE TRINCSGL 3423 241789

My lookup is in columns to the right in the same sheet. I want it to
return the values from Row 1-4. In this example, I1 is the starting
point criteria and I5 is the ending point criteria. So I just want
data in rows that starts with the data in I1 until it sees a different
value in column I and continues through the lookup that way. I hope
someone can help!

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=480232