Hi guys,

I've one question I guess it's pretty simple to solve, but I don't know Excel very well, all my knowledge on that subject comes from programming. So, I have this function that retrieves data from another spreadsheet, but it depends on what line the data is, so the first line looks like that:

=SOMA(Mod1M:Mod5T!B1:F1)

The second:

=SOMA(Mod1M:Mod5T!B2:F2)

The N-th:

=SOMA(Mod1M:Mod5T!BN:FN)

So, what I want is to use the function LIN(), that returns the actual line, in the functions arguments. How I do that?

Thanks for the help.