I would like to find a way of finding out if a number in Column A is located in Column B and if it isn't then for it to be displayed in Column C.
So if I was searching for the number 2 in Column B when it wasn't there but it was in A then the number 2 would be in column C.
Thank you