Index in place of vlookup

[lisa47]

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?

 

[Ronald R. Dodge, Jr.]

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 Help>Creating and Correcting Formulas>ArrayFormulas

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000