Index in place of vlookup
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?
|