View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lisa47 lisa47 is offline
external usenet poster
 
Posts: 1
Default 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?