Finding a value if the user defines its location

[RJMacPherson]

Hey all,

I have a column of numbers in Column J. I also have a cell which I input a number in. I want a formula that then goes to get the number from the row in Column J specified. eg. If I input 10 into the cell, I want the value in J10 to be displayed. Any help would be greatly appreciated!

Cheers.

 

[jasonb75]

Welcome to the board!

Maybe =indirect("J"&A1)

with your value of 10 being entered in A1

 

[RJMacPherson]

Works perfectly! Many thanks for all your help!