Hi all
Sorry I think I may have posted this in the wrong area earlier on in Excel Programing so have reposted here .
I Require a formula that if cell info in sheet1 Table match's cell info in sheet 2 table then themore detail complete row is copied back to sheet 1 to the right of that name.
There are several blank cells that will be copied back to the first sheet that if possible would need to remain blank with no N/A . The data in each row to be copied back to sheet 1 is combination of alpha and numerical data

Sheet1 Name: RacePage
Sheet2 Name: Personal
Lookup value is in Cell: RacePage AZ26
Table Array to search and copy : A2:FO26
name/ data to search in is in A2:A25

cheers
Dave