Cell reference based on value other cell

[JohanL]

Hi Excel/VBA-guys and girls!
I would like to make a cell reference dependable on another cell.
B2 contains value 2.
B13 contains formula: =Output!B2
I would like to make this formula dependable based on the value in B2. So sth like =Output!B (B2)

is this possible?

thank you in advance.
Johan

 

[Fluff]

Hi & welcome to MrExcel.
How about

=INDEX(Output!B:B,B2)

 

[JohanL]

=INDEX(Output!B:B,B2)

hi Fluff, it works . Great! Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.