Varying validation drop-downs based on varying cell values

I am attempting to have cells in Column “U” deliver different drop-down menus based on the corresponding value in column “D”. I have created 7 named lists:
List_117G
List_152
List_JMET
List_XBAND
List_PACWIND
List_VORTEX
List_ROVER

Those lists will be called up based on 7 values in column “D”:
“G”
“152”
“J”
“X”
“D/E”
“V”
“R”

So far I have only been able to get this to work for the first category “G”. When I change the value of column “D” from “G” to “152” I no longer get a drop-down. Here is the formula I am using in the List function of validation.

=IF(D6="G",List_117G,IF(D6="152",List_152,IF(D6="J",List_JMET,IF(D6="X",List_XBAND,IF(D6="D/E",List_PACWIND,IF(D6="V",List_VORTEX,IF(D6="R",List_ROVER,)))))))

What am I doing wrong?

Welcome to the Forum navarreman1!

I can't get your solution to work at all. I get an error message when I try to use that formula in List Validation. Are you sure this is the exact same formula you are using? I believe the error is because you left the last ELSE case blank. I added another list and explicitly used it for the last ELSE case and I do not get the error.

Now, there is still something wrong. You are looking for the number 152 in quotes, so it won't match. Remove the quotes and it works. See attached example.

Ok 6StringJazzer - you steered me in the right direction! The final "," was a mistake. Once I pulled that out things started going a little more smoothly. The big problem I found was that I was populating Column "D" using a validated list and the value "152" was numeric. I changed the validation to " '152 " to input in text format and PRESTO! it works like a champ. It's those minute things that drive me up the wall. Your solution got me started and I thank you for your help.