IF Function skip line if false

Copper Contributor

Hi,

 

I am trying to make an IF Function where if the answer is "false" rather than just leaving a blank cell, Excel will automatically skip to the next line.

 

You will find in my example, that if a product is checked (in the checkbox) on sheet1, I want this product to appear in my table on sheet3. But for the time being, the table will also count the blank cells and this is very annoying.

 

How can I do ?

1 Reply

@emiliebm 

You omitted to attach your example. Please try again.