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}
Created a quick-and-dirty "copy" of your schedule (see picture) and entered the formulae required in C4:C13
=INDEX($K$4:$R$10,MATCH(VLOOKUP(B4,$E$4:$F$15,2,0),$J$4:$J$10,0),MATCH(A4,$K$3:$R$3,0))
If all works well, you should be able to just copy the formula above and paste it in C4 of your own sheet and copy it down.