Hi All....
I'm using this :
MATCH(M45,CHOOSE({1,2,3},X45,Z45,AC45),0)
...to find the index of the value that matches M45. But what I really need is the absolute column number, which I'm pretty much staring at ... either X, Z, or AC ... numerically though. It must be simple, I'm hoping...