index / match Formula
Hi all
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
Last edited by dmcg9760; 11-06-2015 at 10:57 PM.
Reason: more datail
|