I'm trying to set up the below formula for a validation for a list box. If C5
is NSPS, then I want my list to only contain the values in 1 named data range
+ the values of the 2nd named data range. I keep getting error messages. What
am I missing? It's driving me crazy. Thanks for anyones help!

=IF($C5="NSPS",NEWNSPS&NUMBERS,"")

Karen