Is this what you have:

........Acct # .........Info
1.....1011A..........X
2..........................Y
3..........................Z
4.....3822A..........X
5..........................Y
6..........................Z

Biff

"CJLuke" wrote in message
...
I have a report produced by an analytic system that lists separate accounts
and their relevant information. The data is organized by account number so
the account number will appear at the top of the spreadsheet followed by
the
information for the account. The problem is that all of the output is
listed
in one spreadsheet. So, I have to find a function or create my own
function
that will look for the account number and return specific information that
is
listed for that specific account. The following formula gets me close, but
it
only returns the consecutive occurences of a certain parameter.

INDEX(A1:B7,SMALL(IF(A1:A7=A10,ROW(A1:A7)),ROW(1:1 )),2))

If you have a list like the following in A1:B7:

Ashish 234
Sanjay 334
Pongal 434
Ashish 534
Rajesh 634
Suresh 734
Ashish 834

Please email me if you have no idea what I am talking about and I will try
to explain it more fully. It is driving me crazy!!