Validation List... N/A otherwise look to the lists

[dparteka]

Not sure if this is possible but it’ll be interesting to see if it is.

In cell P1 I have this List Validation formula that does the job nicely.
=INDEX(INDIRECT(O1),0,1)

Here's the List Validation in O1:
=IF($L1="CUSTOMER",Lists!$B$8:$B$10,IF($L1="SUPPLIER",Lists!$B$13:$B$15,IF($L1="EMPLOYEE",Lists!$B$18:$B$20)))

I’ve been trying to figure out if I could add to the formula in P1 to include something like this… IF($O1="N/A","N/A")

In regular human language… if O1 is N/A then P1 should also be N/A otherwise look to the lists.

Thank you for looking, your help will be genuinely appreciated.

 

[Chihiro]

Can't you just put "N/A" into Lists!$B$21 and use that in your formula?

 

[dparteka]

Chihiro... thank you for the suggestion. The problem is that P1 has the validation formula =INDEX(INDIRECT(O1),0,1). What happens is P1 is looking to O1 to figure out what list is should be using, so when O1 equals N/A then P1 looks for the list called N/A which does not exist and what I found out is Excel does not allow a list to be named N/A, it doesn't like the "/". Your suggestion however did spark an idea that did work. I just created a list called NA, the only thing that’s in the list is NA.