Linked Drop Downs with associated info

[ronw55]

Is it possible to use linked drop downs with different associated info being displayed in a cell, i.e. cell J1, OD?
I tried using =VLOOKUP(I1,$A$2:$F$6,2,FALSE) but it only works for TFFN. THHN and DLO result in "#N/A".
Is what I want to do possible?

TFFN THHN DLO Type Awg OD 18 0.084 18 0.136 DLO 14 #N/A 16 0.096 16 0.148 14 0.111 14 0.193 12 0.130 12 0.212 10 0.164 10 0.236 <colgroup><col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="7" width="75"> <col style="width: 48pt;" span="3" width="64"> <tbody> </tbody>

<tbody>
</tbody>

 

[NeonRedSharpie]

=if($h$2="tffn",vlookup($a:$b,$i$2,2,0),if($h$2="thhn",vlookup($c:$d,$i$2,2,0),vlookup($i$2,$e:$f,2,0)))

=IF($H$2="TFFN",VLOOKUP($A:$B,$I$2,2,0),IF($H$2="THHN",VLOOKUP($C:$D,$I$2,2,0),VLOOKUP($I$2,$E:$F,2,0)))

There's the same...I just can't get it to be uppercase without having two...because reasons.

 

[ronw55]

Thanks NeonRedSharpie. At first the code would only work for the DLO group. After looking a little closer I noticed that for DLO you had $I$2 before the range and for TFFN and THHN you had it after the range. I moved it in front of the range and then it worked great! Thank you very much!!!