I am trying to return all cells in a column that contain my criteria. I am
using the following command, but I am still getting wrong info back.

=INDEX(B2:B3000,SMALL(IF(A2:A3000=P2,ROW(A2:A3000)-1,""),ROW(A2:A3000)-1))


Any suggestions?

It looks like you are attempting to do an array of cells. After typing in
and/or editing the formula, did you press Ctrl-Shift-Enter to tell Excel
that this is an array formula, not a standard formula? You should see curly
brackets within the formula after pressing this keyboard combination.

To learn more about array formulas, you may go to the following in the Table
of Contents Help File:

Microsoft Excel HelpCreating and Correcting FormulasArrayFormulas

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"lisa47" wrote in message
...
I am trying to return all cells in a column that contain my criteria. I am
using the following command, but I am still getting wrong info back.

=INDEX(B2:B3000,SMALL(IF(A2:A3000=P2,ROW(A2:A3000)-1,""),ROW(A2:A3000)-1))


Any suggestions?