Simple find function

Hi, I am new to VBA and had a simple question. I have a huge spreadsheet and was wondering if there was a vba code or a simple cell equation I could use to see if the cell in A contained the number in cell B. An example is below:
A B C
1 Do something 123 123 Yes
2 Do something 111 987 No
3 Operation 777 777 Yes
4
5

I would like to find a way to create column C so that it says yes when the number in column B is found in column A. Thanks in advance.