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

[weasyb]

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

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%

 

[gaz_chops]

Welcome to the forum.

Try Index/Match

=INDEX($B$2:$F$52,MATCH($H2,$A$2:$A$52,0),MATCH($I2,$B$1:$F$1,0))

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

 

[Aladin Akyurek]

=VLOOKUP(worklocation,A:F,MATCH(classification,INDEX(A:F,1,0),0),0)

should do it. Add the sheet prefix to A:F if needed.

 

[weasyb]

Thank you very much for all of your help! Your solution worked perfectly. I really appreciate your help!

Thank you!!!

Lisa

 

[weasyb]

Thank you very much!!!

 

[gaz_chops]

You're welcome, not sure which you went with, but both should work.

 

[weasyb]

To gaz_chops: your solution worked perfectly, I really appreciate your help! Thank you!!! Thank you, Thank you!!!

To Aladin Akyurek: Thank you very much for your help!

Thank you both very much!!!

 

[weasyb]

I went with your solution. The gaz-chops solution is the one I used first and it worked perfectly. I did not use the 2nd solution because the gaz-chops solution worked.
I also want to thank To Aladin Akyurel who provided the second solution, thank you very much for your time!!!

 

[weasyb]

Thank you very much! I went with your solution because I tried it first and it worked perfectly.
I also thank Aladin Akyurek for his solution and his time.

 

[weasyb]

This post has been solved. Thank you very much to all who provided your time and solutions, all solutions worked perfectly.