Jan 08 2021 08:25 AM
Here is what I want to do.
I want to return a value from column B but the row number will be dependent on what the user enters into cell F5, for example.
So instead of =B5 or some other specific cell in column B
I want column B and whatever value is in F5 for the row number. so =B&F5
So the reference is to cell that is column B but variable to whatever is in cell f5
Jan 08 2021 09:14 AM - edited Jan 08 2021 09:17 AM
Jan 08 2021 09:44 AM
Jan 08 2021 10:41 AM
@alectimmerman Great! Glad I could help solve your problem.