Dynamic reference

[vasco da gama]

Hi.

I want to get a value (from a second sheet) that is located in a cell with a row_number that depends on a value stored in another cell (from the first sheet).

For example:

Sheet A
value in cell A1: 5
value wanted in cell B1: value in cell C5 from sheet B

Thank you.

[NBVC]

Try:

=indirect("'sheetb'!c"&a1)

[vasco da gama]

It works!
Thank you NBVC.