Indirect Lookup Other Worksheet

ScreenHunter_008.jpg

The formula at C2 to C4 are something like this.

When A2=1, C2=Lookup(B2, Sheet1!(A2:A5), Sheet1!(B2:B5))
When A2=2, C2=Lookup(B2, Sheet1!(A6:A9), Sheet1!(B6:B9))
When A2=3, C2=Lookup(B2, Sheet1!(A10:A13), Sheet1!(B10:B13))

What are the formula in C2 to C4, in terms of INDIRECT, OFFSET, ADDRESS , or by other means are alright.