Combining data ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent Drop Down Boxes 1
Validation list from Named Ranges 5
Rank Function: Refer to more than one range 4
change cell color depending on two cell values 1
a data validation list that contains a list of named ranges - not alist from a named range 1
Times 2
Using Formulas for Data Validation 1
Datavalidation with shrinking non blank values 1

Back
Top