Dear Excel experts,

I have a very basic question, I have an existing invoiceTemplate and I
have created 3 separate lists:

DVDs
Books
Others

In the Item column I would like to pull the data from these 3 lists:

Here is it what I want to to:

First of Select whether it's Book, DVD or other
Then go to the Item column and select the Item
if I have selected the DVD then it should Hide books and other item
and vice versa

Looking for advice

I am new to excel.

Many thanks for your help.

Saqi