Use cell contents as part of row number in other cell

There is a number in a cell. I want to use whatever that number is, +8, and use that as row reference in another cell. So B4 contains ‘60’. In another cell I want what is in E68. If the number in B4 is ‘72’, then I want what is in E80.

Thanks,
Doug

Try using INDIRECT like =INDIRECT("E" & B4+8)
See: Documentation/Calc Functions/INDIRECT - The Document Foundation Wiki

2 Likes

That did the trick! Thanks so much.
-Doug

1 Like