I am having trouble with the syntax for this.

=VLOOKUP(B20, SpanCatForce,

IF(AND(C20="4%"), 2,

IF(AND(C20="5%"), 3,

IF(AND(C20="6%"), 4,

IF(AND(C20="7%"), 5,

IF(AND(C20="8%"), 6,

IF(AND(C20="9%"), 7,

IF(AND(C20="10%"), 8,

IF(AND(C20="11%"), 9,

IF(AND(C20="12%"), 10,

IF(AND(C20="13%"), 11,

IF(AND(C20="14%"), 12,"check"))))))))))))

I am trying to look up data in multiple columns where B20 contains the line value and C 20 determines which column to use

Any assistence would be appreciated