Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup combine vlookup with hlookup | Excel Worksheet Functions | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |