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
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
That did the trick! Thanks so much.
-Doug