=INDEX(Entry!J$4:J$999,SMALL(IF(Entry!$A$4:$A$999= $B$4,ROW($1:$995)),ROW(1:1)))

The idea was to input data onto the Entry sheet, and access it on the Owners
sheet by selecting a name from a drop down list in B4 of the owners sheet.

"Ragdyer" wrote:

The Index() function does not necessarily need to be array entered.
It depends on the entire formula.

SO ... how about sharing your formula with us so that we might offer you
some suggestions?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jaytee" wrote in message
...
Excel 2003. Trying to enter an INDEX function. I put in the proper formula
(checked, and re-checked) Then, instead of simply hitting "enter, I hit
"Control-Shift-Enter"

Very seldom does has this actually worked for me, and not at all lately.
What am I doing wrong?