I have a sheet that lists first name, last name, and a column with a letter (A, B, C). I'm trying to retrieve the First and Last Name IF it contains B or C. If it contains A, it's supposed to go to the next row. I've tried many different ways and it comes up differently each time.

1) =IF(ISBLANK(Details!$B89),"",IFERROR(INDEX(CONCATENATE(Details!B89:$B$200&", "&Details!C89:$C$200),SMALL(IF((Details!$E$2:Details!$E$200)={"B","C"},ROW(Details!$E$2:Details!$E$200)-ROW(Details!E$2)+1),ROW(B$1:B90)))," ")) Returns Last Name, First Name but it starts at the first person with the letter B and then EVERYONE after that and then just the "," until it hits the blank.

2) =IF(ISBLANK(Details!$B95),"",IFERROR((SMALL(IF((Details!$E$2:Details!$E$200)={"B","C"},CONCATENATE(Details!B95:$B$200&", "&Details!C95:$C$200),ROW(Details!$E$2:Details!$E$200)-ROW(Details!E$2)+1),ROW(B$1:B96)))," ")) Returns a 1

3) =IF((Details!$E$2:Details!$E$200)<>"A",IF(ISBLANK(Details!$B97),IFERROR(INDEX(CONCATENATE(Details!B97:$B$200&", "&Details!C97:$C$200),SMALL(IF((Details!$E$2:Details!$E$200)<>"A",ROW(Details!$E$2:Details!$E$200)-ROW(Details!E$2)+1),ROW(B$1:B99)))," "))) Returns FALSE

4) =IF(OR(ISBLANK(Details!B93:$B$200),ISBLANK(Details!C93:$C$200)),"",IFERROR(INDEX(CONCATENATE(Details!B93:$B$200&", "&Details!C93:$C$200),SMALL(IF((Details!$E$2:Details!$E$200)<>"A",ROW(Details!$E$2:Details!$E$200)-ROW(Details!E$2)+1),ROW(B$1:B92))),"")) Returns EVERYONE

5) =IF(ISBLANK(Details!$B101),"",IF((Details!$E$2:Details!$E$200)<>"A",CONCATENATE(Details!B99:$B$200&", "&Details!C99:$C$200),SMALL((ROW(Details!$E$2:Details!$E$200)-ROW(Details!E$2)+1),ROW(B$1:B96)))) Returns blank cells

Does anyone have a solution for me? Thanks in advance.