I'm trying to find a formula where I can look up a predetermined value in a table, find the column where that value resides, use that column as my array and then find the nth non zero value to return me the header of that column.
I have played around with a lot of formulas but none of them work, I'm hoping you guys can help.
Bookmarks