I have two tables and want them to be combined via an ID. This is what I have right now:

I want the ID values to match and become this:

I'm struggling finding a way to do this via sorting or formula. The only way I can think to do it is manually but the actual data I have is 4k lines long so doing it manually would be a huge pain.

Thank you for any help or guidance!

CodePudding user response：

If data starts in A1 then:

   =IFERROR(VLOOKUP(B1,C:D,2,FALSE),"")