Forum Discussion
Formulas and Functions copy an array from sheet 1 to sheet2.
I want to type a number into a cell on sheet 2. Then lookup that number on sheet 1 (column A). Then select the horizontal array for this number columns B:F. Insert the selected array into sheet 2 in columns C:G. The typed number varies from 1 to 146.
Assuming you type the number on Sheet2, cell B1:
=XLOOKUP(B1,Sheet1!$A$1:$A$146,Sheet1!$B$1:$F$146)
Fill down.
Thankyou Martin. Your formula worked fine. I have been able to modify it to work on other sheets to give suitable reports.
Again Thankyou
Wayne
So glad it worked and the fact you could modify it to fit your specific case/needs!
Martin
