Merge two sheets and create a third sheet

[CHAITU]

HI ALL ,
I AM HAVING A WORKSHEET ( SHEET 1) WITH THE FOLLOWING DATA

ACC1 , CUS ID , NAME , ADD 1 ,ADD2 ,ADD3 ,ADD4 ,ADD5 ,PIN, PHONE

ANOTHER WORK SHEET ( SHEET 2) WITH

ACC2

THE REQUIRMENT IS THAT THE DATA IN THIRD SHEET SHOULD BE THE MERG OF SHEET 2 AND SHEET1 ,
LIKE SHEET 1 HAS THE WHOLE DATABASE MAYBE 32000 RECORDS
SHEET 2 HAS SOME 200 RECORDS WHICH HAS TO BE SEARCHED AND COPIED IN THE SHEET 3 IN THE FOLLWOING FORMAT

ACC2 , CUS ID ,NAME , ADD 1 ,ADD2 ,ADD3 ,ADD4 ,ADD5 ,PIN, PHONE

pLEASE HELP ME OUT IN DOING THIS

[CHAITU]

HI ALL ,
I AM HAVING A WORKSHEET ( SHEET 1) WITH THE FOLLOWING DATA

ACC1 , CUS ID , NAME , ADD 1 ,ADD2 ,ADD3 ,ADD4 ,ADD5 ,PIN, PHONE

ANOTHER WORK SHEET ( SHEET 2) WITH

ACC2

THE REQUIRMENT IS THAT THE DATA IN THIRD SHEET SHOULD BE THE MERG OF SHEET 2 AND SHEET1 ,
LIKE SHEET 1 HAS THE WHOLE DATABASE MAYBE 32000 RECORDS
SHEET 2 HAS SOME 200 RECORDS WHICH HAS TO BE SEARCHED AND COPIED IN THE SHEET 3 IN THE FOLLWOING FORMAT

ACC2 , CUS ID ,NAME , ADD 1 ,ADD2 ,ADD3 ,ADD4 ,ADD5 ,PIN, PHONE

pLEASE HELP ME OUT IN DOING THIS

[windknife]

sheet3!A2
=IF(Sheet2!A2="","",Sheet2!A2)
copied down Sheet3!A10

sheet3!B2
=IF(A2="","",VLOOKUP($A2,Sheet1!$A:$J,COLUMN(),0))
copied down Sheet3!J10

You can see attached more detail.

HTH,
WindKnife