Hi all,
Please check the attached screenshoot for a better undertanding of my question.
I have a table with several colums (F2:I22) and a header for each (F2:I2).
I would like to enter whatever header name in C2 so that it automatically gets all the data out of the table and puts it in (C3:C22)
Now in my example I just a small table, actually my real table will use about 50 colums with 300 lines.
Anything specific function I can look into to get me going ?
I sort of managed to make it work with an HLOOKUP function but in an not so elegant way. I am sure there must be something better out there (named ranges,... ?)
Any help appreciated
Wanda
Bookmarks