formula using both vlookup & hlookup
My formula is as follows: =VLOOKUP(G2,I5:I9,HLOOKUP(E2,J4:M4,1))
The lookup table looks like this: ("5606" is in I5, "MA" is in J4)
Work comp Rate Table
MA MN OH RI
5606 0.000% 5.026% 0.000% 0.000%
7380 7.412% 0.000% 0.000% 0.000%
8742 0.310% 1.330% 0.000% 0.000%
8810 0.192% 0.490% 0.000% 0.480%
9015 3.888% 9.366% 0.800% 0.000%
The formula encounters an error when it gets to the row index ("1") variable.
What do I need to do to correct the row index?
|