Good Morning Everyone!

I've read all of the 'Contextures Articles' on Dependent Dropdowns, but they
do not seem to address what I am specifically trying to accomplish.

I have a 4000-line spreadsheet used to track hardware and peripherals.
Column A (Category) invokes Data Validation to a list of 39 Hardware Types.

Column B2, for example, would contain the name of the Manufacturer for the
Hardware Type selected in A2 and so on through A4000.

The individual Manufacturer Names [for each of the 39 Hardware Types] in
Category are listed in Columns AA through BM. Three of the Categories I use
are Modem, Projector, and Hub.

What I'm looking for (hopefully) would be a way to use a "large" IF
statement that challenges the dropdown values chosen in A2-A4000 to the
appropriate Manufacturer Names to be dropdown-displayed in B2...B4000.

The 39 Hardware Types are contained [out of sight] in Columns AA-BM.

What I would like to do is something like:

IF A2:A4000 EQUALS "Modem" GOTO AE2:AE20 (Modem Manufacturers)
OR IF A2:A4000 EQUALS "Projector" GOTO AG2:AG24 (Projector Manufacturers)
OR IF A2:A4000 EQUALS "Hub" GOTO AJ2:AJ15 (Hub Manufacturers)
OR IF A2:A4000 EQUALS "Server" GOTO BA2:BA65 .........and so on until
OR IF A2:A4000 EQUALS "Swtich" GOTO BL2:BL43 (our last Category is Switch)

Any thoughts would be most greatly appreciated!

Thanks,
Jeff in Mississippi