Drop Down Menus and IF statements

[Ohrdhor]

I'm currently creating a dropdown menu with multiple dropdowns that is contingent upon what was selected earlier, I figure the easiest way to do this is with an IF statement, so to give an example:

We have:
Brand ###Type###Model###Capacity
Brand A ###R####A1######5
Brand B ###T####A2######10
Brand C ########B1######5
#############B2######10
#############C1######5

What I'm trying to do is you select brand first, and from that you will recieve a second menu, Type where you can select "R" or "T", and in my model above only R should be selectable for C1 (because in my example C1 is a type R). Then you can select the models which have been labeled as either a type R or T and match the brand previously selected and finally a numerical value will be spit out in the Capacity column.

I literally have no idea how to achieve this, please help and hold my hand, you guys were an excellent help yesterday.

Thanks in advance guys!

 

[sous2817]

Hello and welcome to the board! Have a look here:

http://www.contextures.com/xldataval02.html

 

[Ohrdhor]

I took a look at that and while it solves most of my problem it doesn't solve all of it, since my list is rather large (Literally over 400 values for each of the models) and most of them are very specific values I found myself literally naming each cell and using a formula like "=INDIRECT(SUBSTITUTE(B2&C2&D2&E2&F2," ",""))" and just expanding upon that. The names became combinations of about 5-6 previous items and if I need to change anything in the future I'm going to have to rework EVERYTHING.

What I'm asking for is a simpler solution that's more malleable so that I can add data in the future and make changes without having undo and redo everything I've done.