2 Column Lookup with 6 Column array Col index number is Varies Within Entire Array

I have 2 columns that I need to look up from a table with multiple columns and bring back 1 value.

I have tried a regular V-lookup but I cannot make it work because the column index number varies within the entire array because I am trying to match the 2 values.

Any help would be greatly appreciated.

Thank you

Example file is attached.

I need to look up these values:

Work Location/State WC Risk Classification Workman's Comp - Trying to get this value from table below.
TN Very Low
TN Very Low
PA Medium
PA Medium
PA Very Low
FL Low
FL Low
KS Low
KS Low
NC Medium
MA Medium
IA Low
KS Low
SC Medium
MA Medium
MN Medium
IN Medium
GA Very Low
MA Low
MA Low
MA Low
MA Low
NY Very Low
NV Very Low
DE Very Low
DE Very Low
DE Very Low
DE Very Low
FL Medium
SC High
IL High
TX High
NC Very High
NC Very High
NC Very High

From this table:

State Very Low Low Medium High Very High
AK 0.84% 2.95% 7.22% 9.97% 14.71%
AL 0.53% 2.65% 6.25% 7.09% 11.42%
AR 0.36% 1.64% 3.80% 4.18% 6.03%
AZ 0.45% 2.11% 5.12% 5.93% 11.40%
CA 0.85% 4.83% 6.68% 7.79% 8.74%
CO 0.51% 2.02% 4.77% 5.65% 8.96%
CT 0.53% 2.77% 6.34% 7.81% 13.54%
DC 0.37% 1.58% 3.95% 4.26% 6.88%
DE 0.39% 1.85% 6.56% 7.22% 9.73%
FL 0.66% 2.34% 6.10% 7.66% 12.12%
GA 0.49% 2.11% 5.09% 6.09% 10.17%
HI 0.50% 2.02% 4.88% 5.78% 7.12%
IA 0.47% 2.62% 5.54% 7.24% 9.72%
ID 0.51% 2.32% 5.76% 7.50% 9.68%
IL 0.55% 3.21% 8.06% 10.17% 17.98%
IN 0.38% 1.76% 3.98% 4.61% 6.51%
KS 0.47% 2.45% 5.28% 6.55% 8.54%
KY 0.50% 2.25% 5.46% 7.12% 10.40%
LA 0.47% 2.16% 4.72% 5.81% 8.55%
MA 0.35% 1.69% 4.45% 5.40% 10.25%
MD 0.39% 1.77% 4.51% 6.30% 9.00%
ME 0.60% 2.40% 6.89% 7.76% 11.65%
MI 0.54% 2.39% 5.43% 6.32% 10.57%
MN 0.38% 1.58% 3.98% 4.24% 7.39%
MO 0.47% 2.44% 5.19% 6.43% 8.79%
MS 0.54% 2.18% 4.78% 5.80% 8.58%
MT 0.95% 4.16% 9.82% 12.37% 17.34%
NC 0.53% 2.25% 5.57% 6.86% 11.00%
ND 0.48% 1.87% 6.19% 7.30% 7.35%
NE 0.49% 2.28% 5.28% 6.54% 9.67%
NH 0.52% 2.43% 6.34% 7.73% 14.30%
NJ 0.53% 3.22% 6.86% 10.55% 12.34%
NM 0.57% 2.09% 5.04% 5.80% 7.81%
NV 0.68% 2.25% 5.42% 5.77% 8.21%
NY 0.51% 2.43% 5.82% 7.84% 11.15%
OH 0.70% 3.90% 9.01% 10.37% 13.06%
OK 0.68% 2.99% 6.99% 8.91% 11.52%
OR 0.42% 1.90% 4.91% 6.24% 8.42%
PA 0.88% 2.86% 5.97% 6.76% 10.51%
RI 0.49% 2.37% 5.82% 7.47% 11.39%
SC 0.70% 2.45% 5.52% 6.47% 11.68%
SD 0.45% 1.93% 4.60% 5.49% 8.72%
TN 0.49% 2.38% 5.39% 6.49% 10.36%
TX 0.78% 3.19% 7.85% 8.52% 10.52%
UT 0.38% 1.62% 4.02% 4.20% 6.84%
VA 0.37% 1.77% 4.17% 4.67% 7.50%
VT 0.56% 2.94% 7.46% 8.98% 9.80%
WA 1.10% 3.69% 6.81% 10.52% 14.49%
WI 0.53% 2.69% 6.47% 8.12% 11.90%
WV 0.25% 1.61% 4.14% 4.74% 8.78%
WY 1.01% 6.00% 6.11% 6.54% 6.69%

See attached for the following formula in Sheet2:

=INDEX(Sheet1!$B$2:$F$52,MATCH(Sheet2!$A1,Sheet1!$A$2:$A$52,0),MATCH(Sheet2!$B1,Sheet1!$B$1:$F$1,0))

Originally Posted by JohnTopley

See attached for the following formula in Sheet2:

=INDEX(Sheet1!$B$2:$F$52,MATCH(Sheet2!$A1,Sheet1!$A$2:$A$52,0),MATCH(Sheet2!$B1,Sheet1!$B$1:$F$1,0))

Thank you very much for all of your help, your solution worked great!

Kindly mark thread as closed.

Initial thread then "Thread Tools"

Thank you for all of your help! I have marked this thread as closed. Your help is greatly appreciated.

I should have said "SOLVED" ! but no matter: glad to have helped

Thank you again very much, this thread has been "SOLVED", you are a great guy!!! Thank you so much! Cheers!