Forum Discussion
Can't Figure out IF formula for certain Q
I'm trying to align each region with its respective Tax Rate, but the Tax Rate table (Table C) is not in the same order as the Region table (Table A). My current formula for the first box works, but ...
.png){kind=link}
Please give this a try...
In C4
=INDEX($K$3:$R$9,MATCH(INDEX($G$4:$G$15,MATCH(B4,$F$4:$F$15,0)),$J$3:$J$9,0),MATCH(A4,$K$2:$R$2,0))and then copy it down.
If that doesn't work as desired, please upload a sample workbook (NOT AN IMAGE) to work with.