How to find if two inputs in different columns occur in the same row

So I have a set of data with ID numbers that recur. Let's say for example it's people who were called in a call center and some people are called repeatedly, and I have a record for each call. I need to pull a list of all IDs and see which people have had which results.

So for example:

ID Result

123 Voicemail

456 Call back

123 Hang up

789 Hang up

I need to know if each of these people has hung up on us, and if each of them has received a voicemail. Vlookup will only tell me the first result, so I can't rely on sorting the data, since IDs will have multiple results.

I've tried creating a new column with the ID and result in the same cell, but my problem is that I can't figure out how to get Excel to tell me if the cell contains the ID and the result I'm looking for. Result is easy, but there are several hundred IDs, so I can't type them out in the formula. (And of course, the IDs aren't all a consistent length, because the data gods hate me.)

I've also tried an ifand (if(and(ColumnA,A2,ColumnB,B2 etc etc), but that just tells me if those IDs and results occur anywhere in columns A or B, which is not what I need. I need to know if they're in the same row.

I also need to document this process for my boss, who is not a regular Excel user, and ideally set up a sheet so she can just paste the data in and get the result she needs. So ideally I'd love to find a solution that doesn't involve VBA, power suite, macros, etc.

Any thoughts?