Merge Data From another workbook where the ID matches

So I have a column in each of my workbooks that have matching data but they are not in the same order. My issue is i need one of the columns in one of my workbooks to merge into the other workbook where these ids match even though they are not in the same order.

Hi,

I'm not quite sure exactly what you are asking, but if you could attach an example spreadsheet it may make it a bit clearer. We can work from there.

Thanks,

---
Bernieburnham