Excel Formula Help Indirect Function

[imck]

I am trying to get the Text from a Cell in Sheet 1 into Sheet 2 using a Number in Sheet 2 as the Cell reference

Sheet1
A1:Apple
A2:Banana
A3:Orange

Sheet2
A1 should display Banana if Cell B1 is 2, Orange if B1 is 3

In Cell A1
=INDIRECT("Sheet1!A2") Works but I want to replace the 2 with Cell Ref $B$1

Thanks

[bigpriest]

=INDIRECT("Sheet1!A"&B1)

[imck]

bigpriest said:

=INDIRECT("Sheet1!A"&B1)

Perfect Thanks