Formula display if no data

[asyamonique]

=COUNTIF($D$3:$D$500,O2)

Good Day,
Above formula works fine but why there are numerics ıf there is no any data from column D and E ?
Also how can I avoid to display in cells #N/A if no values on related column with given formula below?

=VLOOKUP(O2,$D:$F,2,0)

Many Thanks

 

[Snakehips]

Not sure I understand first question. Are you wanting =IF(COUNTIF($D$3:$D$500,O2)=0,"",COUNTIF($D$3:$D$500,O2))

Second one try =IFERROR(VLOOKUP(O2,$D:$F,2,0),"")


Hope that helps.

 

[Tetra201]

Are you wanting =IF(COUNTIF($D$3:$D$500,O2)=0,"",COUNTIF($D$3:$D$500,O2))

Can be shortened to:

=IFERROR(1/(1/COUNTIF($D$3:$D$500,O2)),"")

 

[asyamonique]

Thanks for both help but the numeric value still appear due to O2 cell has another formula I think that is the reason!
O2 fourmula is

=IF(O1="","",IFERROR(SMALL($D$3:$D$400,COUNTIFS($D$3:$D$400,"<="&O1)+1),""))

Thanks

 

[asyamonique]

ADVERTISEMENT

=SUMIF($D:$D,O2,$J:$J)/60

=IF(COUNTIF($D$3:$D$500,O2)=0,"No Values",SUMIF($D$3:$D$500,O2,$K$3:$K$500)/COUNTIF($D$3:$D$500,O2))

Snakehips
Can I use the same way for to given formulas above to make my worksheet more clean if there are no datas on the target?

 

[Aladin Akyurek]

Try something like:

=IFERROR(IF(VLOOKUP(O2,$D:$F,2,0)="","",VLOOKUP(O2,$D:$F,2,0)),"")<strike></strike>

 

[Tetra201]

=COUNTIF($D$3:$D$500,O2)

Above formula works fine but why there are numerics ıf there is no any data from column D and E ?

O2 fourmula is

=IF(O1="","",IFERROR(SMALL($D$3:$D$400,COUNTIFS($D$3:$D$400,"<="&O1)+1),""))

What are you trying to achieve with these formulas?

 

[asyamonique]

Ohh achieve....
Actually my worksheet is a bit complicated with lots of exported datas from a softwear.
I created master copy which with formulas and vba codes.
Macro opens the target closed worksheet and copy/paste to master file then I get what I needed.
Hope its clear
I'm sorry if I'd bothered to you guys!