Using a Dynamic Drop down to select data to display.

**PheoBlue** · 01-14-2020, 09:03 AM

HI ,

1st time poster.

I am looking for assistance on a spreadsheet i am working on.

I have an Equipment list on 1 Sheet and a Dynamic drop down list on the 2nd sheet ,
At the moment Based on what is selected in the 1st dropdown, data becomes available in the second drop down related to the equipment that has been selected .

What i Ideally wish to do is Populate a Series Of Boxes with data based on the equipment selected in the drop down.
I have created a simple representation of the sheet i am using for playing with.
Ideally I would like to do this without using VB if possible.

Regards
Hugh

**gue2013** · 01-14-2020, 10:03 AM

the red value is the row number (exchange as you need it)

=HLOOKUP(Test1;Search1[[#All];[Vane Anemometer 1]:[Vane Anemometer 3]];2;FALSE)

**PheoBlue** · 01-14-2020, 11:16 AM

HI ,
Thank You,
I Managed to modify your provided Solution to do what I wanted with the Full range instead of just the 3 samples.

=HLOOKUP(Test1,Search1[#All],2,FALSE)

.

Thank You Again
Regards Hugh

**gue2013** · 01-14-2020, 11:20 AM

welcome!

Using a Dynamic Drop down to select data to display.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Using a Dynamic Drop down to select data to display.

Re: Using a Dynamic Drop down to select data to display.

Re: Using a Dynamic Drop down to select data to display.

Re: Using a Dynamic Drop down to select data to display.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Form to display multiple pictures for user select (w dynamic resize & position at runtime)

Dynamic display of values based upon drop-down variable, and flagged rows

I want to select a drop down list item and have it display a unit price in a diff cell

How do I get excel to display acres of the Almond field I select from the drop down box

Drop down to select to display charts

[SOLVED] If I select a value from drop-down list, how to display related info in another cell?

[SOLVED] If I select an option from a drop-down in 1 cell, how do i get it to display specific info

Bookmarks

Bookmarks

Posting Permissions