How to copy selected columns from one sheet to another?

[missy22]

Dear experts,

I am writing to request some help, allowing me to extract rows of specific columns from sheet1, where name is present in columns A, into sheet2. I have an example file attached below, which shows sheet1, as input data and sheet2, as desired output.
final_extraction.xls

Please advice and any guidance would be most appreciated.

Thank you all.

[FDibbins]

If I understand you correctly, try this, copied down and across...
=IFERROR(INDEX(Sheet1!$B$2:$T$10,MATCH(Sheet2!$A2,Sheet1!$A$2:$A$10,0),MATCH(Sheet2!B$1,Sheet1!$B$1:$T$1,0)),"")

[missy22]

Hi, Thank you for your quick response. The formula works great extracting columns from B onwards in sheet2, but it fails to copy name from sheet1 into sheet2.

if its not too much trouble, is this issue feasible into the current formula.

Please advice further. many thanks

[FDibbins]

OK we can do that with a helper column in sheet1 (I used column U) In U2, copied down...
=IF(A2="",U1,U1+1)

Then in sheet2 A2, copied down...
=IFERROR(INDEX(Sheet1!$A$2:$A$10,MATCH(ROW(A1),Sheet1!$U$2:$U$10,0)),"")

You can hide the helper if you want