data validation rule

A

Amin

Hi How do i slove this question? In the order form worsheet, all customer
orders should be based on product in the product_List table. in the range
B2:B20, add a data validation check to ensure that item IDscome from the list
values in the Iem_IDs range
note: the order form is a sheet on its own and the product_List tabl is as
well on a seperate sheet thanks
 
S

ShaneDevenshire

Hi,

Here are the steps for creating a data validation list:

1. Select the range
2. Choose Data, Validation
3. From the Allow drop-down and choose List
4. In the Source box enter the list.

A. Lists can be manually entered: 1,2,Monday,Tuesday (no quotes are
necessary, but the entries should be separated by commas.)
B. Lists can get their data from ranges: =$A$1:$A$10
If you use a range reference, as above, the range must be on the same sheet as the data validation.
If you want to refer to a range on another sheet that range must be named and you references it as =MyList

You can name a range by selecting it and typing the name into the Name Box
(top left side of the Formula Bar) and pressing Enter or you can use the
Insert, Name, Define command.

If this helps, please click the Yes button.
 
A

Amin

Hi ShaneDevenshire, i just tried your sugestion and this is the results
below any thoughts on it? cheers. am suppose to restrict the entries to the
IDs in within the Product_Lis column
Item ID Item Name
=Product_List
=Product_List
=Product_List
=Product_List
=Product_List
=Product_List
 
S

ShaneDevenshire

Hi,

You're not following some step, but I don't know which one.

From the original post:

"If you want to refer to a range on another sheet that range must be named
and you references it as =MyList" or in your case =Product_List.

This doesn't go into the sheet, it goes into Data, Validation, List, Source
=Product_List

How:
"Select the range
2. Choose Data, Validation
3. From the Allow drop-down and choose List
4. In the Source box enter the list. "
 
A

Amin

Hi Shane i have now got my brains back, your sugestion has worked right
thanks for the support
 

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

Top