to choose from a table within a table

[chubbychub]

how can i choose if they pick one option, then the next cell will have a drop donw list according to the first option.
here is the attachment, i want in b2 to show a drop down list from either a list, b list, or c list, depengin on whwat option they chosed

[chubbychub]

is this even possible in excel? if user picks 1 option, then to show in the next cell a list according to the option chosen.
for example, in b2 of the attachments, if user choose wall in b1, then b2 will show "b list" .

[EchoPassenger]

Here's one way...

Essentially you need to use your 'type' values as named ranges.

The lists in columns F-H are all named as per their headers.

The validation source then uses the 'type' value in A2 in an INDIRECT function to refer to that named range.

The only fiddly part is that a named range cannot contain a space, so I have replaced the space in any 'type' values (lazy suzan) with an underscore and then added a SUBSTITUTE function within validation source formula.

Finally I have also added some conditional formatting to B2 that will check if the 'model' value selected is within the 'type' list (as you could technically change the 'model' value after meaning the 'type' value would not match.

I wasn't sure which models belong to which type so I have just used 'option x' for each list - just replace these with your actual values.

I think this is usually referred to as 'dynamic validation' or 'dependent validation'.