How can i skip row in the false case of IF

[fams00]

Hello,
I want to skip the row in the false case.
I use this IF on sheet B only:
IF(AND(LEFT(ALL!A2,3)="BBB",ALL!B2="C"),ALL!A2,"").


I not want any blank row here , i saw people use Small function and some others

[JLGWhiz]

If you mean prevent blank rows on sheet B only so that your data appears on that sheet in consecutive rows, you cannot do it with that formula. You would likely have to use vba macro to do that. But when doing so, you lose the relationship of the row number on sheet All if you only retrieve the column A entry from sheet All.