I am using this code
But I'd like it to return the column header instead of just the column number. Can this be done?Please Login or Register to view this content.
I am using this code
But I'd like it to return the column header instead of just the column number. Can this be done?Please Login or Register to view this content.
When you say column header, do you mean the column letter, or do you mean the value in a header row?
Value of the header, like on a table.
What do you mean by "column header"?
If you mean the column letter you'd use the "ADDRESS" function. In its most basic form the syntax is "ADDRESS(row_num, column_num)", so
will provide the address of the cell found. Trim the number off the end, and you've got your column letter.Formula:Please Login or Register to view this content.
Tim
Never stop learning!
<--- please consider *-ing !
Ok, how about
=INDEX(DX$5:FK$5,MATCH("USA",DX6:FK6,0))
Assuming your header is in row 5
Perfect! That's exactly what I needed!
Haha! Fluff13 got there first!
Not sure who your referring to, but glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks