I have a two tables and I am using the index match formula to lookup data and headers to do some math.
formula in cell G1 is =INDEX($A:$B,MATCH($D2,$A:$A,0),MATCH(G$1,$7:$7,0))*$E2*$C9/100
I want the result to be 9.288 (match should be 92.88*10/100)
So the ask is:
how can I tell...