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 ?
See the file.
If you have questions, on this item, just ask.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hey oedlere, this looks great, but unfortunately not all my tables are as well organized so I cant reference the items in the category, that is why I assigned a number to each column
I don't get it!
I changed the formule and match to the numbers (as you asked).
Please reply if this is what you're up to.
Hey oeldere I was able to get it to work with a combination of your work and a bit of my own, thank you very much
Can you post your solution, I'm interested how you solved it.
So i can also learn of it.
I will one's have it working correctly its still a tad bit iffy.
Glad I could help. Thanks for the reply.
If the question is solved, will you mark your question as solved?
If you have (other) questions, on this item, just ask.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks