Steve,

I find your explanation a bit confusing. You appear to be saying that you
may have only one staring point but many end points, is this correct or do
you mean many (different) start/endpoints? If so can start/ end point
overlap as in:

Start point 1
Start point 2
End point 2
Start point 3
End point 1
End point 3

Would you then want all of the data in Start/End 1 to include or exclude the
data in Start/End 2 and part of the data from Start/End 3?

Also you posted to worksheets.functions - it may be possible to do using
functions but would a VBA answer suffice?
--
Regards


Sandy

Replace@mailinator with @tiscali.co.uk
"SteveG" wrote in
message ...

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