Hi Vadhimoo,

'----------------
One more doubt,Instead of using sheet2, we
want to work with Workbook2.Sheet1 itself . Because Workbook2.sheet is our
main database. Its having large datas. We processed lot of sheets like
workbook1.sheet1.In this case every time we may copy the Workbook2.sheet1's
data and put into the Workbook1.sheet1?
'----------------

I the other workbook is named "My Database.xls", try a formula
of the type:

=VLOOKUP(C2,'My Database.xls'!MyTable,2,0)


---
Regards,
Norman