countif & vlookup

Hi all,


I had get the correct answer if separate the formula (countif and vlookup)
Once i combine it, answer become blank. Please advice.

Formula :
IF(C4="",IF(COUNTIF(M:M, C4&B4)=1,VLOOKUP(C4,I4:K4,2,0),""),"")

Please refer to attachment.

Thank you

Regards,

I think you want:

=IF(C4<>"",IF(COUNTIF(M:M, C4&B4)=1,VLOOKUP(C4,I4:K4,2,0),""),"")