Search beginning from last match

[NewExcelUser]

I found this post on another board and it accurately describes what I am looking to do... any takers? I've been trying combinations of offset, with the address function + row and I just cant get it right. Thank you for your time.

Is there any way to do something like this...

Please Login or Register  to view this content.

Say that returns a value of 3. The match is in the 3 row from A4, or A7
Now I want to do a match again starting at A8

Please Login or Register  to view this content.

Basically I want to start the search array over again starting off where the last one was found + 1

[shg]

=MATCH(1, OFFSET(A4:A80, MATCH(1, A4:A80, 0), 0):OFFSET(A4:A80, 76, 0), 0)

Messy, but non-volatile.

[NewExcelUser]

Hi, thank you for your time.

In my struggles with this, I have actually come up with this function....

Please Login or Register  to view this content.

Woah! This is one of the longest functions I have constructed in Excel thus far (yipee!) Unfortunately, it doesn't work. I get a N/A value returned. Why is this?

What I am trying to do is take data (W2) which is matched up with information in another column (R1:R2001) -this data is actually contrived from a formula which pulls from column A - get the address (from W1 match) and have it offset from that address to find the next match in (W2).... and then offset from that address to pull the desired information....

I have this formula, which works great

Please Login or Register  to view this content.

The trick is starting another search from the address value of the formula above...

Make sense?... I hope... Thanks...

[shg]

And you tried the formula I provided, but ... what?