Match - loopup-array

[Flemming Dahl]

Hi,

I am trying (without any luck) to create a list based on a matrix.

Column A looks like this:

1
1
2
1
4
2
3
1
4
2
......

On one sheet I have created at list based on values = 4, and I have found
the row numbers like this
A2 =MATCH(4,Sheet1!A:A,0)
A3 =MATCH(4,INDIRECT("Sheet1!A"&A2+1&":A65536"),0)
A4 =MATCH(4,INDIRECT("Sheet1!A"&A3+1&":A65536"),0)

How can I make the same list on another sheet and get the row numbers for
rows with value 1, 2, 3

Something like thise formula merged into one formula
=MATCH(1,Sheet1!A:A,0)
=MATCH(2,Sheet1!A:A,0)
=MATCH(3,Sheet1!A:A,0)

Thanks,
Flemming

 

[Flemming Dahl]

Solved in another way - don't spend your time on this one.