Copy worksheet from another worksheet using condition

**vkkumar** · 10-10-2006, 11:12 PM

Dear All,

I have two worksheets namely LTA and INV. I want to copy values from another a source worksheet to a distination worksheet after comparing two columns in both worksheets. For example:

INV.XLS

INVNO LICNO
100 100
101 101
102 102
103 103
104 104
105 105

LTA.XLS
BILLNO VEHNO
100
102
105
101
104
103

If you see the above example the column BILLNO in LTA.XLS is blank. Now I want to copy the values of column INVNO in INV.XLS into this after comparing the column values LICNO=VEHNO.

Can any expert help me in this regard?

**davesexcel** · 10-11-2006, 01:39 AM

place a formula like this beside the billno column

=VLOOKUP(A1,[inv.xls]Sheet1!$A$1:$B$6,2,FALSE)
=VLOOKUP(A2,[inv.xls]Sheet1!$A$1:$B$6,2,FALSE)
=VLOOKUP(A3,[inv.xls]Sheet1!$A$1:$B$6,2,FALSE)
=VLOOKUP(A4,[inv.xls]Sheet1!$A$1:$B$6,2,FALSE)
=VLOOKUP(A5,[inv.xls]Sheet1!$A$1:$B$6,2,FALSE)
=VLOOKUP(A6,[inv.xls]Sheet1!$A$1:$B$6,2,FALSE)

**vkkumar** · 10-11-2006, 02:20 AM

Hi dave,

thanks for your prompt reply. I tried but it is not working. PLEASE KINDLY SEE THE ATTACHED ZIP FILE EXTRACT IT AND VIEW THE EXCEL FILE WITH SHEET1 AND SHEET2.