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!