Good after noon,
I need help, I have a table I am trying to look up based on a column number, is there a way to do this. Basically say I have 20 columns, 5 rows deep or high, and at the top of each column I have it numbered from 1 to 20, Now is there a way to refrence that number so that all the data in that column (the 5 rows) is produced.
Below is a sample work sheet of what I want, one sheet one is the table on sheet two you enter the number and it produces that column is this possible ?
Bookmarks