You could use INDEX function.
Here is my test.
Data is listed as below in Sheet2.
In Sheet1, I used =VLOOKUP(A2,Sheet2!A2:F9,2,FALSE) in cell B2, =VLOOKUP(A2,Sheet2!A2:F9,3,FALSE) in cell C2 and so on.
Then you could change the number in A2 to you want.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.