Linked Drop Downs with associated info

R

ronw55

New Member
Joined
Aug 8, 2014
Messages
8
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?

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 536"]
<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>[TR]
[TD="class: xl64, width: 75, bgcolor: transparent"]TFFN[/TD]
[TD="class: xl65, width: 75, bgcolor: transparent"] [/TD]
[TD="class: xl64, width: 75, bgcolor: transparent"]THHN[/TD]
[TD="class: xl66, width: 75, bgcolor: transparent"] [/TD]
[TD="class: xl64, width: 75, bgcolor: transparent"]DLO[/TD]
[TD="class: xl66, width: 75, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 75, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]Type[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]Awg[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]OD[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]18[/TD]
[TD="class: xl64, bgcolor: transparent"]0.084[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"]18[/TD]
[TD="class: xl64, bgcolor: transparent"]0.136[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"]DLO[/TD]
[TD="class: xl64, bgcolor: transparent"]14[/TD]
[TD="class: xl64, bgcolor: transparent"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]16[/TD]
[TD="class: xl64, bgcolor: transparent"]0.096[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"]16[/TD]
[TD="class: xl64, bgcolor: transparent"]0.148[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"]14[/TD]
[TD="class: xl68, bgcolor: transparent"]0.111[/TD]
[TD="class: xl64, bgcolor: transparent"]14[/TD]
[TD="class: xl64, bgcolor: transparent"]0.193[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"]12[/TD]
[TD="class: xl68, bgcolor: transparent"]0.130[/TD]
[TD="class: xl64, bgcolor: transparent"]12[/TD]
[TD="class: xl64, bgcolor: transparent"]0.212[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]0.164[/TD]
[TD="class: xl64, bgcolor: transparent"]10[/TD]
[TD="class: xl64, bgcolor: transparent"]0.236[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
Code: 
=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)))

Code: 
=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.
 
Upvote 0
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!!!
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
VBA Help with Array of text
2 3
Replies
21
Views
2K
decadence
D
A
  • Question Question
Linking dynamic data with drop down
Replies
1
Views
218
Ashley W
A
C
  • Question Question
Sort and count cell based on two drop down list
Replies
2
Views
527
Copan1795
C
S
  • Question Question
Advance Drop Down
Replies
0
Views
201
skruege3
S
GLower0617
  • Question Question
Dynamic Drop Down List
Replies
1
Views
231
GLower0617
GLower0617

Forum statistics

Threads
1,224,811
Messages
6,181,081
Members
453,021
Latest member
Justyna P

Share this page

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
Back
Top