Excel help

[Mark M]

How can I make it so that the below column B lines up with column A and includes the information in column C. Hope that makes sense?

I dont want to just sort it as the real data that Im using has thousands and thousands of entries.

 

[Mark M]

Ive cracked it, vlookup with the data moved to a seperate sheet