Index command in excel

[Anokh]

Hello

I want to know Index command in excel. If anyone have the info about the same Please provide me. I don't have much knowledge about excel.

Thanks

[Feoras]

you can use finished INDEX function within a cell reference or other command to get the values you want into their destinations.

[darshit]

The INDEX formula look something like this:

=INDEX(INDIRECT(A1&"_Table"),...)

This appends "_Table" to the selected text in A1 and and INDIRECT converts the text string to an addressable range name for INDEX to use