I need some help--the formula below gives me a blank cell if the value is
"I"--but what I want is that if the value is "I" to not return value--so that
only values of "A" will appear on my list.

In addition--when there is no data--it is returning a value of "False"--how
do I get it to return a blank cell?

=IF(Roster!$A8="I","",IF(Roster!$A8="A",IF(Roster! $H8="Y",INDEX(Roster!B8,0),"")))

Any help will be greatly appreciated!