Excel Question #46

[Kevy Baby]

Originally Posted by Alex

Hey Kevy, I'm just curious. Did you get a chance to try this and were the instructions clear?

I didn't, but I have now

I did find a minor error in your formula: you had switched the A12 and B12 references in the Match portion of the formula

=INDEX(A1:D4,MATCH(B12,A1:A4,0),MATCH(A12,A1:D1,0) ) <-- you had
=INDEX(A1:D4,MATCH(A12,A1:A4,0),MATCH(B12,A1:D1,0)) <-- this worked

When I applied it to my own needs, I ran into trouble because I was swapping the two matches (basically, trying to make the first match on the horizontal axis and the second on the vertical). Once I found my error, it worked - thank you.

Now to move it past the testing phase and put it into real world!