Hi
Please help me to create the formula
please go through the attach file
in Sheet1 I have some data
in Sheet2 if I entered any ACC no which is there in A1 of Sheet1 the Last Reopen Date should automatically pick from Sheet1
is this possible with any formula?

Regards
Arindam