Hi All,
What is the proper syntax for?
=E((B4-1)*8+5)
I am trying to pick out the information stored in E5, E13, E21, etc, based on the value of B4, which is hard coded to 1,2,3,4…
Many thanks,
-T
E5, E13, E21 are on a different sheet called Loads
=INDIRECT("$Loads.e"&((B4-1)*8+5))
Thank you!!!
Correct answer was given by @SM_Riga. The cells being on a different page was never mentioned in the OP.
The original question left out the sheet for simplicity. I marked it as an answer because it included the complete syntax I needed. And it about killed me to figure it out, so I shared to help others. I also marked SM’s response as an answer because he had answered to original simplified question.
Only one response can be marked as the accepted answer. The only one marked is yours. The upvote on SM answer was placed there by myself.
Also, questions should be complete. If you are looking for something, ask. That information can lead to other possibilities. That is partially the reason there are many comments asking for more information.