Changing the Row value in a formula based on value in another cell

[danedw]

I am trying to build a dynamic formula where the row value changes based on the number value in another cell.

My first effort to write the formula was
=a"b2"

The data is in row A

The number variable is in cell b2. So if the value is B2 was "12" the formula would show me the value of A12

I want to use it to bring up a single row of data by entering the row number in a single cell.

[AliGW]

Have a look at the INDIRECT function.

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

[danedw]

All good figured it out. Indirect is my friend.
=INDIRECT("a"&b2)

[oeldere]

C2 =indirect("a"&b2)

[AliGW]

Glad to have helped.

Please check and update your forum profile!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.