How to check if a value exists in another column | Excel

Answer is at 1:20 - 2:25
In this video I show you have to check if a value exists in another column and or worksheet. I also show a fix for sorting on formulas in Excel. The sorting issue was found during the making of this video and I decided to leave it in.
As always thanks for watching and comment if you have a specific question, you would like an answer for.