Hi folks, just a quick question.

I have 2 sheets with data on property.

Sheet 1 has column A and B
Sheet 2 has column C

A and C both contain unique property numbers which 99% match up (there are a few in column A that aren't in C and vice versa). Is there anyway for me to copy column B into Sheet 2 and get it to line up with column C so that the unique property numbers sync up.

Hope I've phrased that ok for you'se all.

Cheers.