If else statement for partial cell match VBA

This is an extended question from Partial cell match

From this question, I managed to do an if statement. But I realised that I need an else statement too.

So when I added else to the if statement. It did not work accurately.

I tried by "elseif not" but it doesn't work neither. Any idea how do I change?