... Not the cell location but the actual data ..
It's even simpler then ..
In E1, copied down: =IF(ISNA(MATCH(D1,A:A,0)),"",D1)
Success? hit the YES below
--
Max
Singapore
---
"Zuo" wrote:

Almost there but I want the actual matching reference that is sitting in A1
to appear in E4 next to its match on D4. Not the cell location but the
actual data. i.e. if A1=23 and D4 =23 then 23 should appear in E4 or next to
D4.

Thanks.