need formula that can search criteria then return entire row

i want to be able to change the titles but if i enter title 4 I want to pull the rows beneath it that are checked.

For instance title 4 would return the following values
a red
c yellow
e blue
f purple

if title 1 is entered the formula would return
a red
c yellow
f purple

procedure description title 1 title 2 title 3 title 4 title 5
a red x x
b orange x x x
c yellow x x
d green x x x
e blue x x
f purple x x x x

Nick's picture

can't you use autofilter ?...

can't you use autofilter ?... or am I missing something...