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

If by list box you mean Data Validation, you cannot do whay you want using
DV. If it's not DV, then which List Box is it?

I am sure you will need code to get your desired result.

"Karen" wrote:

> 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