Copy the formula downward. This will cause the final arguement, ROW(1:1) to
change, causing the formula to pull the 1st isntance, then 2nd, then 3rd,
etc...
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"worksheet functions" wrote:

I can make the formula look up anumber but i need it to look for a specific
word. What can i replace "SMALL" with to have the formula bring all intances
of the word "Active" =SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1) )