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

weasyb

New Member
Joined
Aug 4, 2015
Messages
11
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%
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,485
Platform
  1. MacOS
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))

Code:
[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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
=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

New Member
Joined
Aug 4, 2015
Messages
11
Thank you very much for all of your help! Your solution worked perfectly. I really appreciate your help!

Thank you!!! :)

Lisa
 

weasyb

New Member
Joined
Aug 4, 2015
Messages
11

ADVERTISEMENT

Thank you very much!!!
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,485
Platform
  1. MacOS
You're welcome, not sure which you went with, but both should work.
 

weasyb

New Member
Joined
Aug 4, 2015
Messages
11

ADVERTISEMENT

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

New Member
Joined
Aug 4, 2015
Messages
11
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

New Member
Joined
Aug 4, 2015
Messages
11
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

New Member
Joined
Aug 4, 2015
Messages
11
This post has been solved. Thank you very much to all who provided your time and solutions, all solutions worked perfectly.
 

Forum statistics

Threads
1,141,048
Messages
5,703,928
Members
421,321
Latest member
blusky4

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top