hi all,
Check out my sample, Ive been trying with with index and match but keep getting errors, not sure if it is because its vertical looking up horizontal, or blank cells in the range...


The sample workbook is pretty self explanatory -I have 1 workbook with 2 sheets:

Sheet 1
In column A SHEET 1 I would like all the text cells from ROW 1 SHEET 2 to appear.
In column B I would like the contents of row 10 that matches the name in column A -

I am trying this with index and match but constant errors - dont know if its because of blank rows...
Also if there is a better way to point sheet 1 names to sheet 2 names :-(
AND if rows are added or deleted it must still point to that data...


Sample attached if you can help
http://www.4shared.com/document/MLGp..._sample_2.html


thanks all