Conditional List Box using table as a source

[mrlIT]

Hi everyone,

I am hoping someone is able to help me.

I want to create a data validation list using a table as a source for the data.
My excel workbook has a table called "AllAssets" which contains various columns of data.
i want a list box that will display only values from the "Asset Tag" column where the corresponding value in the "Type" column = "Desktop"

[TABLE="width: 500"]
<tbody>[TR]
[TD]Asset Tag[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]MRL1001[/TD]
[TD]Printer[/TD]
[/TR]
[TR]
[TD]MRL1002[/TD]
[TD]Desktop[/TD]
[/TR]
[TR]
[TD]MRL1003[/TD]
[TD]Desktop[/TD]
[/TR]
[TR]
[TD]MRL1004[/TD]
[TD]Printer[/TD]
[/TR]
[TR]
[TD]MRL1005[/TD]
[TD]Desktop[/TD]
[/TR]
</tbody>[/TABLE]

in the example table above, the list box needs to only display MRL1002, MRL1003 and MRL1005 from the "Asset Tag" column because it matches "Desktop" in the "Type" column.

How can this be achieved in Excel 2007?

Cheers.

 

[SteveO59L]

see Aladin's classic solution, here

http://www.mrexcel.com/forum/excel-questions/32-cascading-combo-boxes.html

 

[mrlIT]

Thanks SteveO59L for your response.
I have had a look in the linked thread you posted and I couldn't see how to make it work.

I only want a single drop down list box, not multiple list boxes linking to each other.
i.e. a single list box that would only list specific items from Column A if the adjacent cell in Column B matched a value of "Desktop".

It's probably something easy to do, but I just don't know how to make it work.

Cheers.