help with index

[m4a2t0t]

I dont understand how to use the index function. I read the help here and tried using

=Index(Data, 7, 29),

The problem im having is that I dont have any columns with numbers, only letters..lol

Maybe im using the function incorrectly. All I want to do is copy data that is on one sheet to another sheet.

[BigBas]

You are correct in noting that columns are generally denoted with letters.

The index function syntax does not require you to enter the column number (or letter) to calculate; instead, it asks you to indicate which column in the array you need to pull information from.

For example, if you have this function:

=INDEX(B5:E15,2,4)

the function will pull information that is in cell E6 (that is the 2nd row down in the array, and the 4th column across in the array)