Using Direct Reference as starting point for Named Lists

[Tootlez]

Scouring through the internet, watched many videos, and read a few other articles, (one which i thought would help but they were using Open Office, and I didn't feel like downloading it just to view 1 file, and my luck it not be helpful) anyways...

I have 4 sheets.
Sheet 1 is my working/gathering sheet, Sheets 2 and 3 are my data sheets. Sheet 4 is my Lists.

I'm trying to fill out two different systems logs with the same info. Sheet 2 is simple, and Sheet 3 is more specific, but not exact enough to use VlookUp.

I thought about doing If statements, but I run out of my 64 nested If's without even going half way through the results. I was thinking a VlookUp but it needs to be exact match to grab it, and these options have /'s in them and it's confusing to me to even read some times. So after a while of rolling this through my head, I thought of lists.
PLEASE if you can think of a better way, Let Me Know!!!

So right now I have my Sheet 3's cell equal to my Sheet 2's value, but I need to use the list that I collected to make a drop down FROM THAT VALUE...
In my lists sheet I took all of the potential values that the Sheet 2's value can be and made it a list: Type.
For each "Type" i have a list of the values that match the best for that 'type', THESE are the values that I need in a drop box to select from.

Two examples to help clear things up:

EXAMPLE1:

ITEM: Ashley Brownstone Chaise
Sheet 2: Type = Chair
Sheet 3: Current Value = Chair
Drop Box =​

Chair and a Half
Chaise Lounge
Massage Chair
Accent Chair
Bean Bag Chair
Fuf Chair
​

EXAMPLE2:

ITEM: Bradley Upholstered Gentlemen's Chest
Sheet 2: Type = Dresser
Sheet 3: Current Value = Dresser
Drop Box =​

Dresser
Bachelor's Chest
Bureau Chest
Door Chest
Gentleman's Chest
Lingerie Chest
Media Chest

​

Hopefully in simpler terms:
So from the current cell's value (or honestly if I would just look up Sheet 2's value for that cell), then determine from the list "Type", and return the list associated to that type...
I really hope this made sense....

 

[Tootlez]

I believe that I might have solved my own question.

I ended up using

=INDIRECT(SUBSTITUTE(VLOOKUP(P2, Type, 1, 0), " ", "_"))