How can I make it so that, depending on the value in a stand-alone cell, the data of one selected column is displayed without using the "IF" function?

Question

Google Sheets

Good day, I apologize for the incorrect essence of the question, I did not understand how to briefly explain. There is a table, 30 columns, in another Google table, you need to display the data of one column of your choice. those. there is a cell where we indicate a number, let's say from 1 to 30 (equal to the number of columns), and by entering, for example, the numbers "5", next to the main table (or on another sheet), all data of the "5" column is displayed. Tried through IF, but it turns out a huge formula.

Answer 1

Most likely, INDEX will suit you. For example, to get the fifth column of a range, you can
=INDEX('Данные'!A:AA;;5)
If you enter 5 in C1, then
=INDEX('Данные'!A:AA;;C1)