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.