G
ghost
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? 
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?