Formulas and Functions copy an array from sheet 1 to sheet2.

[Wayne_Goodwin]

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.

[#2]

@Wayne_Goodwin 

Assuming you type the number on Sheet2, cell B1:

=XLOOKUP(B1,Sheet1!$A$1:$A$146,Sheet1!$B$1:$F$146)

Fill down.

[#3]

@Martin_Angosto 

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

[#4]

@Wayne_Goodwin 

So glad it worked and the fact you could modify it to fit your specific case/needs!

Martin