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!

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!

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!

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

That's good. Could you press the YES in that response, to close off your
query.

Would you happen to know how to remove the blank rows? ...

Suggest you start a new thread for your new query. Include more info.

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---