How to make formula return blank value when cell is empty

[Jyggalag]

Hi all,

I have the following formula:

The formula checks if the value in column D is located anywhere in sheet 2's values in the array B1:D133.

However, when I pull the formula down, it also checks blank cells. Is there any way to edit this formula, so when it checks a blank cell (for example cell D8 as shown in the picture above) the formula will also return a blank cell instead of TRUE/FALSE?

Thank you all!

Kind regards,
Jyggalag
Conqueror of Svork

 

[RoryA]

=if(D8="","",your countif formula here)

should do it.

 

[Jyggalag]

=if(D8="","",your countif formula here)

should do it.

It works! Thank you so much Rory! True MVP again