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?

why not use match to find the row and match to find the column and index to
get what you want

--
Don Guillett
SalesAid Software

"xFreeAdvice" wrote in message
...
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?

Excellent suggestion.
Thank you for your help.

"Don Guillett" wrote:

why not use match to find the row and match to find the column and index to
get what you want

--
Don Guillett
SalesAid Software

"xFreeAdvice" wrote in message
...
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?