Jul 04 2024 10:17 PM
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.
Jul 04 2024 10:45 PM - edited Jul 04 2024 11:00 PM
Assuming you type the number on Sheet2, cell B1:
=XLOOKUP(B1,Sheet1!$A$1:$A$146,Sheet1!$B$1:$F$146)
Fill down.
Jul 05 2024 01:46 AM
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
Jul 05 2024 01:50 AM
So glad it worked and the fact you could modify it to fit your specific case/needs!
Martin