View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TXDalessandros TXDalessandros is offline
external usenet poster
 
Posts: 24
Default Validation in Field Lists

I have a spreadsheet that I need to click choice either yes or no in column E
to populate based upon the field they choose in Column H (example Below
CEI
No
No

Field
To/Consignee
To/Consignee
To/Consignee
To/Consignee
To/Consignee
Dimensions/Weight
To/Consignee
To/Consignee
From/Shipper
To/Consignee
From/Shipper
To/Consignee
To/Consignee
From/Shipper

I have made lists for Yes and No possible values and I have defined the
names as such the CEI column is names as such as well. However it is just
not working.