Indirect function with two references by using + sign

[vidplaylist]

I have one indirect formula which has 2 references within brackets by using + sign. Can someone please explain what + sign functionality within indirect formula.

Thanks,

 

[Ruddles]

Nothing special as far as I'm aware. The + operator is used to add to numbers together and it will also concatenate two strings.

Being able to see your formula would help us provide a more precise answer.

 

[vidplaylist]

This is the formula
=MATCH($N$2,INDIRECT("'Sales'!c"&A5+1&":c"&4+'Sales'!$C$2),0)

 

[RoryA]

That just adds 1 to the value in A5 to get a row number.

 

[vidplaylist]

This is little explaination of formula, first part is calculating range and after + sign second part is a reference which has a value of 15

Indirect(range C10:C4+ value in reference cell is 15)

Hope this will better explain

Thanks again,