Find value in range, and copy unique values not found plus adjacent column value to new cell

[wilkiej]

Hi Guys

Apologies I was not able to find what I was looking for in the forum.

I have 3 columns.
Col A = ID (10,000 items)
Col B = unique ref number (10,000 items)
Col C = ref list number to check against (1700 items)

What I would like to do is use a vba macro to check each item in Col B against the item list in Col C.
If no match is found for Col B in Col C, then copy the value from Col B and the adjacent value from Col A to a new columns (or a new sheet)