Max,
Thank you for your help --your formula worked! It returns a blank cell where
it appeared as "false" before!

Would you happen to know how to remove the blank rows? For the value
"I"-the formula returns a blank row--is there a way to eliminate the blank
rows for all values of "I" so the values for "A" appear sequential?

"Max" wrote:

Perhaps this is what you meant to do:
=IF(Roster!$A8="I","",IF(AND(Roster!$A8="A",Roster !$H8="Y"),Roster!B8,""))

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Wilma" wrote:
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!