Pb with Data validation based on named list

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
 
R

Roger Govier

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.
 
G

Gilles P (FR)

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
 
R

Roger Govier

Hi Gilles
Then try placing the values you want in cells A1:A2 of Sheet2and name Test
as Sheet1!A1:A2
 
R

Roger Govier

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
 
G

Gilles P (FR)

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
 
R

Roger Govier

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.
 
Top