=Sheet2!$B$ get number reference from another cell

Hello!

I have a list of about 2500 words that I need to pull into another sheet based on the word ID (please see sample sheet because it will make sense then). These words have been grouped into around 150 groups.

I know I can type '=Sheet2!$B$' and then type the word ID is, but I would like to be able to drag and replicate the formula so that the row number it takes the word from in sheet 2 column B is dependent on the number in the cell to the right hand of where I am typing the formula.

I've attached an example sheet so you can get clearer. I would really like to save myself from typing reference numbers all manually - please help! Thank you!

I think that you mean:

B4:

Formula:

Please Login or Register  to view this content.