Quote:
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!