I've attached the document with comments describing what I need Excel to do. Please help me because I'M LOSING MY FREAKING MIND. Thanks!
I've attached the document with comments describing what I need Excel to do. Please help me because I'M LOSING MY FREAKING MIND. Thanks!
This in T3 and dragged across will work
It doesn't need to be this complex if the titles are always in the same order BUT this will ensure that if the orders are changed the formula should still work
=INDEX($H$3:$M$3,MATCH(INDEX($A$1:$F$1,MATCH(O3,$A$3:$F$3,0)),$H$1:$M$1,0))
Happy with my advice? Click on the * reputation button below
Thanks for the rep points. I gather this is closed so could you mark it as solved ? Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks