Match and copy cell value to the row where it find the match

Good Day everybody! I recently joined this forum as I found it very helpful for people like me who loves programming . I am a newbie in programming macro so pardon me if you find my question very elementary.
Actually I have a table that needs to be updated by using a match command. i have a workbook with two sheets named "Data" and "Form". In the "Data" sheet, i have a table of different products in column A. What I need is to copy the row of data in the "Form" when it find the match in "Data" sheet and copy it to the row where the product is located.
Thanks in advance!!!

Hi and welcome to the forum

You dont need VBA for this, INDEX/MATCH will do it for you

Give it a shot, and if you still have a problem, upload a sample workbook and we can put something together

The syntax is...
=index(criteria-to-find,column-to-search-in,0),row-number,column-number)
=match(criteria-to-find,column-to-search-in,0) 0 returns exact match
=MATCH(criteria-to-find,row-to-search-in,0)
soooo that gives us...
=index(criteria-to-find,match(criteria-to-find,column-to-search-in,0),match(criteria-to-find,row-to-search-in,0)