Issues con INDEX function

[Aristerneris]

Good afternoon everybody!

I am currently taking an specialization final test and I am stuck with one of the questions...please help me!

I am using this expression: =INDEX(Rate_500!C3:G6,2,3) and I get a value.

I need use this same expression to get values from the same sheet and the same range, but I must express it in this way: =INDEX("Rate_"&.05*10000&"!"&C3:G6,2,3)...but, with this expression i just get the name of the sheet: Rate_500!

I don´t know what I am doing wrong...please somebody help me!.

Note: the last expression is written in that way because with it I have to extract information of another sheets and the name will be varying.

 

[kweaver]

You cannot index a quotation. If, for some reason, you have to have it in that odd form, you'll need to convert the TEXT into something that can be indexed.

Something like this:

=INDEX(INDIRECT("Rate_"&0.05*10000&"!C3:G6"),2,3)