Formula to copy data from one row to another through matching

[tnickless]

Here is my formula that I'm looking to build off of:

=IFERROR(VLOOKUP($A1,Table2,10,FALSE),"")

I don't know if I can use just a formula or if it has to be a macro. I am trying to create a query of one column in a list. The query will be for an ID in column A. This query will be done against another worksheet in the same workbook. (Table1 and Table2)

If the ID of the first worksheet matches the ID in the other worksheet, it will copy data from column J of Table1 to column J of Table2.
There are only two columns that will be used in this formula. Column A contains IDs for the initial lookup while Column J contains the data that needs to be copied

My formula already works but I need it to actually copy the values over to column J instead of just referencing. If I need to explain better/more, I'd be more than happy to do that.

[Pepe Le Mokko]

If you enter

Please Login or Register  to view this content.

in col J of Table2, it should work