If A1 is present in column B, get C. How do I make it?

I actually learned a great deal from this post by @ThinhDinh

There are some really great tips in here and best practices to follow.