Compare values in two columns and print the corresponding next call value.

[Ashwin Sundarajan]

I have a sheet which contains values in columns A, B, C and D.
I want to compare the values in D with A and if any value in D matches with A it has to print the value of B in E.
I need a formula to do this.
I used if(iserror(match())), but not sure how to print the corresponding B value in E
To say in simple ways, compare D with A and print the corresponding agent name(B) in E
I have attached an example Excel Sheet

[dluhut]

What happened if col A although have the same Ticket Number, but have different agents?

[Ace_XL]

In E2

Please Login or Register  to view this content.

Copy down

[dluhut]

Assuming if Ticket Number in Column A always unique, you can do a quick vlookup. Put this formula on Cell E2

Please Login or Register  to view this content.

[Ashwin Sundarajan]

Thank you guys! This helped me. I will have to manually remove the duplicate data.

[dluhut]

You can 'know' the duplicates through pivot table or formula function, rather than eye-balling through it