Match? Maybe?

[mhenk]

I'm dealing with an irritating spreadsheet that my boss threw together and now I'm trying to summarize.

Is there anyway to return the value immediately under the occurance of a certain number in a column? (col. E, to be exact)

Example:

1
24507
34523
2343

2
345345
5645

3
124234


I would like to be able to create a summary table off to the right of all this data, and return something like this
1 | 24507
2 | 245245
3 | 123234

Any assistance would be grand!

 

[Oaktree]

=INDEX(E:E,MATCH(1,E:E,0)+1) will return the number below the first 1
=INDEX(E:E,MATCH(2,E:E,0)+1) will return the number below the first 2, etc.

Of course, if your data is
1
2
something else

2
foo
bar

The first "2" will throw off this calculation. Hopefully, from your sample, this isn't an issue.

 

[mhenk]

Right, it's not an issue,thanks. Works perfectly, btw!