How to read E"&S5+1&":E"&4 ? Can someone explain

[vidplaylist]

Indirect formula help

=INDIRECT("'sheet1'!e"&S5+1&":e"&4+'sheet1!$C$3)

Can someone tell me how to read the red highlighted part of the indirect formula. I have this formula in one sheet but i am struggling to understand.

Thanks in advance,

 

[vidplaylist]

How to read E"&S5+1&":E"&4 ?

I have this statement part of a formula and i am struggling to understand this.

Thanks,

 

[kpark91]

You probably forgot a " at the front.

"E" & S5 + 1 & ":E" & 4

& is used for string concatenation
so if you have 4 in cell S5, it would look like

E5:E4

as

"E" & S5 + 1 & ":E" & 4
"E" & 4 + 1 & ":E" & 4
"E" & 5 & ":E" & 4
E5:E4

 

[Joe4]

I merged your two threads into one.

In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

 

[vidplaylist]

Thanks, Ok sure

 

[vidplaylist]

Ok, sure

Thanks,