how do I reference a row number based upon some value of a function?
My data is in Column B. But the actual row number depend on some other condition.
ideally, I want something like this in my formula
=T("the actual value is "&sheet1.B(rowNumber(output of function)))
if the output of a fuction is “23”, then, essentially I will see
=T("the actual value is "&sheet1.B23)