Match a cell value in another sheet and copy values below the cell (Index Match)

Hello everyone,

I have an excel file in which I have 2 sheets.
Sheet 1 has values from 1 to 100 from B1 to CW1 and data from B3 : CW103 (100 values)
Sheet 2 has some values between 1 to 100. (Example: 1, 3 & 5)
I need to get the data from Sheet 1 to Sheet 2 and paste the values from B3:CW103 in Sheet 2.

Desired Output sheet is added.

I have attached my excel file for reference.

Someone please help me.
Thanks in advance.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Thanks for the title change

Try this in B3, copied down and across...
=INDEX('Sheet 1'!$B$3:$CW$32,MATCH('Sheet 2'!$A3,'Sheet 1'!$A$3:$A$32,0),MATCH('Sheet 2'!B$1,'Sheet 1'!$B$1:$CW$1,0))

Good stuff, happy to help and thanks for the feedback