W
Wilma
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!
"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!