Formula to return more than one value - Please help!!!!!

joshuav81761

=INDEX([Job Name]1:[Job Name]15, SMALL(IF([Job Number]22=[Job Number]1:[Job Number]15, ROW([Job Number]1:[Job Number]15)-ROW([Job Number]1)+1), ROW(1:1)))

Paul Newcome

I'm not sure I follow. What exactly are you trying to accomplish? Can you provide more details?