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

Copper Contributor

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.

 

3 Replies

@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.

@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

@Wayne_Goodwin 

 

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

 

Martin