Thread: Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PG
 
Posts: n/a
Default Validation

Ok, I have this problem with validation. Can I do the following or is there a
work around.

=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12),IF(E6="CMIN",$IQ $14,$IQ$4:$IQ$12))

It would seem to work but it doesn't. The first part works fin.
=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12)