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

Please post a sample sheet with some data and desired results - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post