Getting the absolute column number from a non-contiguous match result.

[spacely]

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...

Thank you in advance!

Dave

 

[spacely]

Answered on another older thread:

=index(choose({1;2;3},column(x41),column(x45),column(x48)),match(m41,choose({1;2;3},x41,x45,x48),0))