Copy if match from another workbook

[hubba]

Hi All,
Been trying to do the following,
I have a workbook called RollerTemplate and I would like to set up the other workbooks to check this RollerTemplate workbook when the macro is run. The template has about 1500 entries in the Columns, Column A would be the Matching Column and then Columns B to F would have the data needed to be copied across in to the other workbooks.

Basically the other work books are quotes for products, I am wanting it to run a macro against column D12 to D24 this would MATCH these part numbers against the template workbook in Column A then it would copy the data in to J13 to N13 from Columns B1 to F1 where the match is located.

Also would like it in a Button, but i think i just need to copy the macro in to the button properties?

Have tried MATCH and a few others but can not get it to work.

Thanks
Hubba

 

[ravishankar]

Hi
vlookup can help you.
J13 = vlookup(D13, [rollertemplate.xls]sheet1!$A$1:$a$1500,2,FALSE)
K13 = vlookup(D13, [rollertemplate.xls]sheet1!$A$1:$a$1500,3,FALSE)
L13 = vlookup(D13, [rollertemplate.xls]sheet1!$A$1:$a$1500,4,FALSE)
Extend 2,3,4 upto 6(N13).
Ravi