As-is, you could try this in E2:
=INDEX(B:B,MATCH(D2,A:A,0)+1)
where D2 contains the name, eg: Zia
Format E2 as date to taste

If you can take a layout re-design, put the 2 different dates into separate
cols. Makes things neater and easier to associate & work with.

Any joy? wave it, hit YES below
--
Max
Singapore
---
"Zia Butt" wrote:
S.NO Name "Pay Date/Paid Date"
A B
1 Zia 01/01/2010
2 03/01/2010
3 amir 12/12/2009
4 01/01/2010

Find the value for Zia (A1) from crossponding column B but row no 2 (B2)
whch is " 03/01/2010"