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

Question

excel

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, on another page (or nearby) 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. I tried using IF, but it turns out a huge formula and excel refuses to read it, but you just have to make a choice of one column out of 30 or more.

Answer 1

Insert the following formula into the entire column:
=ДВССЫЛ("RC"&A1;0)
, where A1 is a reference to the column number