CODEWITHSUNDEEP
excelexcel-formula
user2406786
user2406786

Reputation: 59

How to compare and match two tables that aren't the same?

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

Date

I want the ID values to match and become this:

enter image description here

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!

Upvotes: 0

Views: 372

Answers (1)

guest55
guest55

Reputation: 36

If data starts in A1 then:

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

Upvotes: 2

Related Questions