Pb with Data validation based on named list

  • Thread starter Thread starter Gilles P (FR)
  • Start date Start date
G

Gilles P (FR)

Hello,

I create a Name as Test = {"A" , "B"} (not a range but a list of datas)
by the menu 'Insert" / "Name" / "define"

Then i cant'use that name "Test" in the Data validation Combo box
by the menu "Datas" / "Validation" / "Option" / "Autorize" (List)
The error message is that system does'nt accept in "Source" = Test

Where is the Probleme

thanks for your help

Gilles PROVOST
 
Hi Gilles

You don't need the named range.
In Data Validation>List>Source>A,B

No need for the = sign before your list of values, just a comma (or ; if
that is your Regional separator) between each item you wish to allow.
 
Thanks for this way of solution but,...
I need to have an defined name for the drop-down list items because i re-use
this name in a MATCH() function in others range of the worksheet.

Regards,
Gilles
 
Hi Gilles
Then try placing the values you want in cells A1:A2 of Sheet2and name Test
as Sheet1!A1:A2
 
Apologies, that should have read

Then try placing the values you want in cells A1:A2 of Sheet2 and name Test
as =Sheet2!A1:A2
 
Hey,
Really sorry to insist on it,

By my target is to avoid a new sheet only for store two datas....

However Thanks for your answers

Gilles
 
Gilles

You don't have to use another sheet.
Use any spare cells on your existing sheet.

There is no problem in using another sheet, however, it can be hidden if you
wish.
 
Back
Top