How to find duplicate cells in Column a & retrieve column B
A B C D E
1 abc cba =vlookup(c1,a1:a4,1,false) 2
2 cba€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€ ¦€¦€¦

What I want to do is retrieve the A value in E according to the value in D1?€ƒ