Pick a row based on value in formula

[robertdseals]

Hello,
I want to look up the value in column H based on the row in whatever number is in cell A9. So, I want to do something like ="H"&Value(A9).

 

[63falcondude]

Try =INDIRECT("H"&A9)

or

=INDEX(H:H,A9,1)

 

[mumps]

Maybe:

Range ("H" & Range("A9").Value)

 

[AliGW]

Maybe this?

=INDEX(H:H,A9,0)

 

[robertdseals]

Perfect! Thanks everyone for the help.