Combining data ranges
 

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

Combining data ranges
 

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